I am working with Firebird 2.1.3 32bit Classic Server. I'd like works with chinese characters in UTF8 database. So I created database with UTF8 character set and I inserted chinese characters in unicode sequence form. Everything is OK, but I need sorting these chinese characters no by unicode but chinese collation. Firebird has GB_2312 character set where is GB_2312 and GB_2312_UNICODE collations.
My question is : Can I create chinese collation (GB_2312) for character set UTF8? I tried use statement CREATE COLLATION ..... FOR .... from .... but this didn' t works for me . The UTF8 character set is not in fbintl.conf file.
According to the manual, you can only use the collation GB_2312 with the character set GB_2312. So you will need to change the character set of your database (or at least of that column which you want to sort by)