读书人

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

发布时间: 2012-02-11 09:51:34 作者: rapoo

请教: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

读书人网 >Sybase

热点推荐