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