Subject Re: [firebird-support] Error on UTF8 in concatenation?
Author Ivan Prenosil
> 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)

Ivan