Subject | Re: [firebird-support] UTF8 in firebird ? |
---|---|
Author | Geoff Worboys |
Post date | 2012-01-06T00:45:02Z |
Vander Clock Stephane wrote:
all the UTF8 codepoints not characters. Once you understand
the difference you will also understand that to do so means
that none of your indexes, sorting etc will work properly.
If you want simple byte storage and to hell with proper
unicode character collation then use character set OCTETS.
If you want to Firebird to collate your characters as is
appropriate for a given locale then use the character-set
relevant to that locale or use UTF8 to get full unicode
support and wear the cost.
--
Geoff Worboys
Telesis Computing Pty Ltd
> no, you can store in iso-8859-1 ALL the UTF8 char :)No this is incorrect. What you can store in ISO-8859-1 are
all the UTF8 codepoints not characters. Once you understand
the difference you will also understand that to do so means
that none of your indexes, sorting etc will work properly.
If you want simple byte storage and to hell with proper
unicode character collation then use character set OCTETS.
If you want to Firebird to collate your characters as is
appropriate for a given locale then use the character-set
relevant to that locale or use UTF8 to get full unicode
support and wear the cost.
--
Geoff Worboys
Telesis Computing Pty Ltd