1,查看你已经装载了的字符集
select name,id from syscharsets;
select name,id from syscharsets;
2,如果没有你所需要的cp936,则装载
charset -Usa -P****** -Ssybaseserver binary.srt cp936
charset -Usa -P****** -Ssybaseserver binary.srt cp936
3,修改default字符集为你需要的cp936
sp_configure "default character set id",171
sp_configure 'default sortorder id',id
sp_configure "default character set id",171
sp_configure 'default sortorder id',id
4,reboot server (twice)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22363020/viewspace-695119/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22363020/viewspace-695119/