Hello all,

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.

Does anyone have any idea?
Thank's

I'm not sure what you are trying to achieve.

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)