Subject Re: [firebird-support] UTF8 database and extended characters in metadata
Author Martijn Tonies
----- Original Message -----
From: "Adriano dos Santos Fernandes" <adrianosf@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, November 13, 2008 11:08
Subject: Re: [firebird-support] UTF8 database and extended characters in
metadata


> Martijn Tonies escreveu:
> > Hi,
> >
> >> In an UTF8 database ( Fb 2.1 ), trying to create a table via Database
> >> Workbench which uses IBObjects:
> >>
> >> create table "ÅÄÖ"
> >> ( id integer)
> >>
> >> I get:
> >> arithmetic exception, numeric overflow, or string truncation Cannot
> >> transliterate character between character sets
> >>
> >> However, in FlameRobin, this works fine.
> >>
> >> When retrieving the columns for this table, I get:
> >> ISC ERROR CODE:335544436
> >>
> >> ISC ERROR MESSAGE:
> >> SQL error code = -104
> >> please retry, giving a database name
> >>
> >> But I have the feeling this message is incorrect (wrong firebird.msg?)
> >
> > It seems to be the error message:
> > Malformed string
> >
> Use the correct connection charset for your platform.

Which is? :-)

I was using UTF8...

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Sybase
SQL Anywhere, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com