Hi,

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

returns this error on an UTF8 database:
arithmetic exception, numeric overflow, or string truncation


Yes, I'm connected with the UTF8 charset, so I figured it might have to
do with the concatenation OR the system tables not being UTF8.

If I remove the || '=' part, it works fine though.

Got any clue?

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