> > 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?
>
> I think it is the same error like
> http://tracker.firebirdsql.org/browse/CORE-1255
> (which is fixed in FB2.1)

Right, this particular SQL is generated by IBObjects. Could the fix
be backported to 2.0x?

I've already sent the workaround to Jason.

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