当前位置: 代码迷 >> Sybase >> 请问:sybase12.51 查询出现的字符集有关问题!
  详细解决方案

请问:sybase12.51 查询出现的字符集有关问题!

热度:7291   发布时间:2013-02-26 00:00:00.0
请教:sybase12.51 查询出现的字符集问题!!
sybase12.5查询报错如下:  
  select error:SQL Server is now using a multi-byte character set, and the TEXT character counts have not been re-calculated using this character set for table 'sq_grda'. Use DBCC FIX_TEXT on this table before running the query again.  
  Server Message: Number 3621, Severity 10  

我的SYBASE12.5字符集为cp936。
ID为171


1> sp_helpsort
2> go

 Collation Name Collation ID
 ------------------------------ ------------
 defaultml 20
 thaidict 21
 iso14651 22
 utf8bin 24
 binary 25
 altnoacc 39
 altdict 45
 altnocsp 46
 scandict 47
 scannocp 48
 dict 51
 nocase 52
 nocasep 53
 noaccent 54
 espdict 55
 espnocs 56
 espnoac 57
 rusnocs 59
 cyrnocs 64
 elldict 65
 hundict 69
 hunnoac 70
 hunnocs 71
 turknoac 73
 turknocs 74

 Loadable Sort Table Name Collation ID
 ------------------------------ ------------
 cp932bin 129
 dynix 130
 gb2312bn 137
 cyrdict 140
 turdict 155
 euckscbn 161
 gbpinyin 163
 rusdict 165
 sjisbin 179
 eucjisbn 192
 big5bin 194

Sort Order Description

 ------------------------------------------------------------------
 Character Set = 171, cp936
  CP936 (Simplified Chinese).
  Class 2 Character Set
 Sort Order = 50, bin_cp936
  Binary sort order for simplified Chinese using cp936.
(return status = 0)
1>

各位朋友麻烦给想想办法,谢谢了

------解决方案--------------------------------------------------------
我这里有一份sybase专门修改字符集的word文档

要的话加我QQ:554059395
------解决方案--------------------------------------------------------
更改SYBASE默认字符集为CP936
------解决方案--------------------------------------------------------
更改SYBASE默认字符集为CP936