Hi David,

--- In firebird-support@yahoogroups.com, "hay77772000" <dhay@l...> >
I'm trying my best to get my head around what we need to do to

> support Chinese (simplified) and Korean.

Support of Simplified Chinese is possible by using
character set GB_2312. Unfortunately I know next to
nothing about CJK collations (sort order), so I can
only hope, that GB_2312 in its binary sort order
is of some use.

Support of Korean is provided by character set
KSC_5601 and there is even an additional collation
in the source tree, named KSC_DICTIONARY, which sounds
rather promising.

When using UNICODE_FSS (UTF-8) you would only have
Unicode codepoint order as the only collation, so despite
its theoritcal pros, there are severe practical contras.

For current Firebird (including 1.5) you won't get any
support for the extended set of ideographs defined in
GB18030 and the non-BMP planes of Unicode.

> Is there anyone out there that has actually used Firebird to support
> simplified Chinese and/or Korean?

I've got at least one other support question for
GB_2312, and after clarifyinmg some basics, no further
complaints.

Regards,
Peter Jacobi