linux下修改sybase服务端字符集

例如修改字符集为eucgb

1.查询sybase系统中已加载的字符集

isql -Usa -Pxx -Sxx

1>select name,id from syscharsets

2>order by name

3>go

2.若没有加载eucgb字符集，加载

$cd /home/sybase/charsets/eucgb

$charset -Usa -Pxx -Sxx binary,srt eucgb

3.修改默认字符集

1>sp_configure "default charater set id",170

2>go

4.将sybase重启两次

isql -Usa -Pxx -Sxx

1>shutdown with nowait

2>go

$./start -f RUN_XX

$./start -f RUN_XX

5.查看字符集命令

isql -Usa -Pxx -Sxx

1>sp_helpsort

2>go