下图是SAP Cloud for Customer对中文字符的排序结果:
在HANA studio上打开trace:
设置trace file name:
构造测试数据:
DROP TABLE TEST_SORT;CREATE TABLE TEST_SORT ( SID INTEGER,CNAME NVARCHAR(100),ENAME NVARCHAR(20));INSERT INTO TEST_SORT Values (1, '山东', 'ShanDong');INSERT INTO TEST_SORT Values (2, '华为', 'Huawei');INSERT INTO TEST_SORT Values (3, '爱活力', 'Aihuoli');
执行select:
select * from TEST_SORT ORDER BY CNAME desc;
找到trace file:
从trace file发现HANA是按照中文字符的Hexadecimal排序:
所以才会有如下结果:
ResultSet.columnLabel = [SID:INTEGER, CNAME:NVARCHAR, ENAME:NVARCHAR] (thread 29569, con-id 300136) at 2017-09-11 15:54:31.140189ResultSet.row[1] = [3, u'''xE7x88xB1xE6xB4xBBxE5x8Ax9B''', u'''Aihuoli'''] (thread 29569, con-id 300136) at 2017-09-11 15:54:31.140204ResultSet.row[2] = [1, u'''xE5xB1xB1xE4xB8x9C''', u'''ShanDong'''] (thread 29569, con-id 300136) at 2017-09-11 15:54:31.140210ResultSet.row[3] = [2, u'''xE5x8Dx8ExE4xB8xBA''', u'''Huawei'''] (thread 29569, con-id 300136) at 2017-09-11 15:54:31.140216
爱活力 will be bigger than 山东 and 华为.