Subject Re: [firebird-support] ISQL, UTF8 connection: "show table " gives error -802
Author Adriano dos Santos Fernandes
skoczian escreveu:
> Hello,
>
> using Firebird 2.1.1.17910.0 on Gentoo Linux I get an error I didn't
> ever see before: if I call ISQL using charset UTF8, the
> statement "show table xxx" is correctly executed, but it ends with
>
> Statement failed, SQLCODE = -802
> arithmetic exception, numeric overflow, or string truncation
> Command error: show table country
>
> This happens for databases with default character set UTF8 or
> ISO8859_1. It doesn't happen for the same databases, if I connect
> using charset ISO8859_1. But UTF8 is my system charset, so it
> certainly doesn't make sense to use ISQL with connection charset
> ISO8859_1, if the database has default character set UTF8.
>
> My metadata don't contain any non-ASCII characters.
>
> Other statements are executed correctly and without unexpected error
> messages, including "show view xxx" or "show trigger xxx".
>
> What's happening here?
>
This is already registered bug - CORE-1690. It seems I now know real
reason of it, and will try a fix.


Adriano