Subject Re: [IBO] Error when using UTF8 charset during metadata queries?
Author Martijn Tonies
Hello Jason,


> I don't know what to do about this issue.
> It seems there is a need of some kind of transliteration.
> Where do we look first?

As I said, this query seems to raise the error:

> > SELECT R.RDB$RELATION_ID || '=', R.RDB$RELATION_NAME
> > FROM RDB$RELATIONS R
> > ORDER BY 1 ASC

This seems to fix it:
SELECT cast(R.RDB$RELATION_ID as varchar(10)) || '=', R.RDB$RELATION_NAME
FROM RDB$RELATIONS R
ORDER BY 1 ASC

I just did a quick cast to see if the problem was solved.

Alternatively, I guess you could remove the concatenation altogether
and just use the string value in your code instead.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com