|Subject||Re: [firebird-support] Error on UTF8 in concatenation?|
> > This SQL:Right, this particular SQL is generated by IBObjects. Could the fix
> > 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
> (which is fixed in FB2.1)
be backported to 2.0x?
I've already sent the workaround to Jason.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!