Subject | Re: [IBO] Error when using UTF8 charset during metadata queries? |
---|---|
Author | Martijn Tonies |
Post date | 2007-02-28T13:13:38Z |
Hello Jason,
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
> I don't know what to do about this issue.As I said, this query seems to raise the error:
> It seems there is a need of some kind of transliteration.
> Where do we look first?
> > SELECT R.RDB$RELATION_ID || '=', R.RDB$RELATION_NAMEThis seems to fix it:
> > FROM RDB$RELATIONS R
> > ORDER BY 1 ASC
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