This section describes two sort orders, gbpinyin and gbinyinnocs, supported in Adaptive Server version 15.0.2 ESD#1. These sort orders support these Chinese character sets:
EUC-GB
GB-18030
CP-936
UTF-8
GBPINYIN is a Chinese phonetic ordering, where the order is based on Chinese Pinyin pronunciation.
GBPINYINNOCS is the combination of GBPINYIN and NO-CASE ordering, in which Chinese characters are ordered by Pinyin pronunciation, and Latin characters are ordered as case-insensitive.
Use these stored procedures:
sp_helpsort
sp_configure
To populate the syscharsets table with the new sort orders:
select sortkey (null, 'all')
To list the new sort order ID:
sp_helpsort ------------ Name ID ------------------------- gbpinyin 163 gbpinyin_eucgb 163 gbpinyin_gb18030 163 gbpinyin_p936 163 gbpinyinnocs 26 gbpinyinnocs_eucgb 26 gbpinyinnocs_gb18030 26 gbpinyinnocs_cp936 26
For example, enter:
sp_configure 'default sortorder id', 26
