Selecting Case-Insensitive Sort Orders for Chinese and Japanese Character Sets

Use the sp_helpsort and sp_configure system procedures to select case-insensitive sort orders.

sp_helpsort lists the available case-insensitive sort orders.

sp_helpsort
-----------
Name                   ID
-------------------------
nocase_eucgb           52
nocase_cp936           52
nocase_gb18030         52
nocase_eucjis          52
nocase_sjis            52
nocase_deckanji        52

Use sp_configure to switch to a case-insensitive sort order:

sp_configure 'default sortorder id', 52