I am using the ISO8859_1 character set for a database in Norway. Using
IBOConsole, I can update the tables with Scandinavian characters
without problem.

I think the error you are seeing is coming from the database. Since
Unicode has multi byte characters, are you trying to enter more
characters than the column width (in bytes) permits?

Dave

--- In firebird-support@yahoogroups.com, "mailmur" <mailmur@y...> wrote:
snip
>
> I downloaded IBOConsole and tested it with my current FB1.5.0.4290
> installation. I have a database with UNICODE_FSS default charset.
>
> Registered localhost server, registered TESTUTF database and then
> tried to insert non-USascii letters (a with two dots, a with ring etc
> scandinavian letters).
>
> "Trying to post a new record it just gives me the following error.
> ISC ERROR CODE: 335544321, aritmetic exception, numeric overflow, or
> string truncation. Cannot transliterate character between character
sets."
>
> I have tried few Java based dbManagers but they lack too much
> features. But Java and/or dotNet should give a smooth full unicode
> support from point to point. Maybe native UIs, like IBOConsole, dont
> cope with unicode charsets well enough.
>
>
> Table SQL
> ============
> CREATE TABLE "Customer" (
> "id" INTEGER NOT NULL,
> "Name" VARCHAR(50) CHARACTER SET UNICODE_FSS,
> "Code" VARCHAR(3) CHARACTER SET UNICODE_FSS NOT NULL,
> CONSTRAINT "PK_Customer" PRIMARY KEY ("id")
> );
>