Submitted by: henryxu (henryxu)

Attachments:
TESTGBK.FDB
InsertSQL.sql

There's wrong order for Chinese characters if database is with CHARACTER SET GBK.

Test case:
1. Create Database
SET SQL DIALECT 3;
CREATE DATABASE 'D:\TestGBK.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET GBK

2.Create Table
CREATE TABLE TB_CHINAPORT (
FID BIGINT NOT NULL,
FPORTCH VARCHAR(20),
FPORTEN VARCHAR(20));

3.Insert Record
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (1, '??', 'SHANGHAI');
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (2, '??', 'NINGBO');
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (3, '??', 'SHENZHEN');
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (4, '??', 'WENZHOU');
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (5, '??', 'XIAMEN');
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (6, '??', 'ZHANJIANG');
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (7, '??', 'DALIAN');
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (8, '??', 'QINGDAO');
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (9, '??', 'TIANJIN');
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (10, '??', 'SHANTOU');
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (11, '???', 'ZHANGJIAGANG');
INSERT INTO TB_CHINAPORT (FID, FPORTCH, FPORTEN) VALUES (12, '??', 'GUANGZHOU');

p.s.
Field "FPORTCH": Chinese Port with Chinese characters:
Field "FPORTEN": The Chinese Spell for Field "FPORTCH"

4.Test "ORDER BY"
SELECT FPORTCH ,FPORTEN
FROM TB_CHINAPORT
ORDER BY 1

Result is wrong:

FPORTCH FPORTEN

?? SHANGHAI
?? XIAMEN
?? DALIAN
?? TIANJIN
?? NINGBO
?? GUANGZHOU
??? ZHANGJIAGANG
?? SHANTOU
?? SHENZHEN
?? WENZHOU
?? ZHANJIANG
?? QINGDAO

the correct order(same to ordering by FPORTEN)

FPORTCH FPORTEN

?? DALIAN
?? GUANGZHOU
?? NINGBO
?? QINGDAO
?? SHANGHAI
?? SHANTOU
?? SHENZHEN
?? TIANJIN
?? WENZHOU
?? XIAMEN
??? ZHANGJIAGANG
?? ZHANJIANG

p.s.:
If CHARACTER SET is GB2312,the result is correct.