Hello Brad,

> I'm using FirebirdCS 2.1.2 on SuSE 11.1 Linux and I create a database
> specifying the default character set to be UTF8. I then connect to
> the database and specify that I'll be using UTF8 for the connection.
> If I then select on any "char" type column, I get back a string that
> is 4 times the length it should be and blank padded.
>
> So for instance if I have a char(1) column and store 'Y' or 'N' in it
> and select on it, I get back 'Y ' or 'N '. The problem doesn't
> happen with varchar columns and if I change the character set used for
> the connection to ISO8859_1, then the problem goes away.
>
> I expect that if the database is UTF8 and I'm talking UTF8 to the
> server and I store 'Y' in a char(1) column, when I select from it I
> should get 'Y' back again!
>
> PS: this is all using the C fbclient library and I'm setting the
> connection character set using isc_dpb_lc_ctype in my connection
> parameters.

I've seen this when using IBObjects, can someone else confirm this too?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com