Subject Re: [firebird-support] Problem with character set - Plz reply immediatelly
Author Michael Weissenbacher
Hi,
> 1. Does Firebird 1.5.2 supports UTF8 as the character set?
Yes it does - but in a very limited way tbh. Sorting happens in binary
order for example. In fact UTF8 is just an alias to UNICODE_FSS in
1.5.2. Proper support has been implemented in FB2.
> 2. When I am trying to create a firebird Database using 'UTF8' or
> 'UNICODE_FSS' as character set I am not able to create a primary key
> with length morethan 65 characters. Can Any one specify me, What is the
> maximum length of the primary key when these two character sets are
> used.
The maximum key length is 252 bytes (or something like that). With
UNICODE_FSS every character needs 3 bytes, that's why the key can't more
than 65 chars. This has changed in FB2, but FB2 is not released yet.

hth,
Michael