Subject Re: [firebird-support] UNICODE_FSS trouble
Author Helen Borrie
At 09:02 PM 22/05/2006, you wrote:
>I'm french and i use Firebird.
>Since some days, i have a trouble with my firebird database.
>I use it via , and embedded firebird.
>When i select records, firebird don't send accent characters (french and
>other) !
>The charset is UNICODE_FSS. How can i read all characters ?

If you mean that the DEFAULT CHARACTER SET attribute of the database
is UNICODE_FSS, then make sure that you also have the character set
attribute of the client set to the same. How you do this depends
entirely on what you are using as your data access interface.

Contrary to what Adam stated, the UNICODE_FSS implementation is not
"incomplete / doesn't work properly". It works as designed. It's
just that it is a very limited implementation - all characters are a
static 3 bytes and there is no upper/lower case mapping. But if the
client is correct then it should return the unicode_fss characters as stored.

Fb 2.0 implements UTF-8 support, and that's a different story. It is
a separate character set.