TIBQuery order by

[fausten]

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

[ViktorV]

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.