Question

sybase12.5数据库安装cp936,现在是iso_1的字符集，导致C++程序的客户端乱码。

数据库安装cp936

1.c:\> cd \sybase\charsets\cp936 　2.c:\sybase\charsets\cp936>; charset –Usa –P123456 -SSUNSHINE binary.srt cp936

3.在Isql环境中:select name,id from syscharsets ↙（ctrl+E）
找到name为cp936对应的id为171
sp_configure "default character set id",171 ↙（ctrl+E）
但是执行sp_configure存储过程时报错。
错误信息：
1> sp_configure "default character set id", 171
2> go
Msg 5824, Level 16, State 4:
Procedure 'sp_configure', Line 695:
Cannot reconfigure server to use sort order ID 53, because the row for its
underlying character set (ID 171) does not exist in syscharsets.
(return status = 1)

Answer 1

需要先设置sortorder，sp_configure “default sortorder id”，50.