Devart Forums

I created a table with UTF8 character set. for example: create table aaa(fld varchar(100));
and insert value into the table:
1) insert into aaa values('中国');
2) insert into aaa values('美国');

I want to order the fld field by collate GB_2312, so the row with '美国' can show top.
How can I do that with TIBCQuery?

there is a clause in create database statement. but cannot specify the collation GB_2312 for UTF8. the collation for UTF8 can only be: UCS_BASIC,UNICODE ,UTF-8 and UNICODE_CI_AI.

anybody knows the way to add GB_2312 to the collation set ?

thanks a lot

This question is not related to IBDAC functionality. It is related Firebird architecture specificities. To resolve the issue, please contact Firebird tech support or ask your question at specialized forum.