Subject | ISQL, UTF8 connection: "show table " gives error -802 |
---|---|
Author | skoczian |
Post date | 2008-08-20T14:08:45Z |
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?
Thank you,
Herta
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?
Thank you,
Herta