sybase-字符集合.docVIP

sybase-字符集合 可以看出，数据库默认字符集是英文，而我们检查/opt/sybase/locales/locales.dat文件中关于sybase客户端的字符集设置，已经将更改为“locale = C, us_english, iso_1”这一行的“iso_1”改为“eucgb”，说明客户端字符集设置的为“eucgb”。数据库与客户端默认字符集不同，导致从客户端上登录出现乱码；那么如何在SYBASE数据库上设置中文字符集EUCGB呢？ 解决方案： 1.检查数据库是否存在“eucgb”字符集： #cd /opt/sybase/OCS-12_5/bin #./isql -SN2000DBServer -Usa -Psybase 1 select id,name from syscharsets 2 go 若存在170（id） eucgb(name),则表示EUCGB字符已经安装，否则则需安装EUCGB字符集： 进入/opt/sybase/charsets目录检查是否存在“eucgb”目录；执行#charset Usa Psybae -SN2000Server binary.srt eucgb命令为SYBASE服务器安装“eucgb”字符集。 # cd /opt/sybase/charsets/eucgb # ls binary.srt charset.loc eucgb.cfg utf8.ctb # charset -Usa -Psybae -SN2000Server binary.srt eucgb Loading file binary.srt. Found a [sortorder] section. This is Class-1 sort order. Finished loading the Character Set Definition. Finished loading file binary.srt. 1 sort order loaded successfully 2.登陆SYBASE服务器，再次检查SYBASE服务器上的EUCGB字符集设置情况: 1 select id,name from syscharsets 2 go id name --- ------------------------------ 0 ascii_8 1 iso_1 2 cp850 3 cp437 4 roman8 5 mac 50 bin_iso_1 50 bin_eucgb 170 eucgb 表明字符集EUCGB安装成功 (9 rows affected) 4.设置“eucgb”为默认字符集： 1 sp_configure default character set id,170 2 go In changing the default sort order, you have also reconfigured SQL Servers default character set. Parameter Name Default Memory Used Config Value Run Value ------------------------------ ----------- ----------- ------------ ----------- default character set id 1 0 170 1 (1 row affected) Configuration option changed. Since the option is static, Adaptive Server must be rebooted in order for the change to take effect. (return stat