Sybase IQ 在windows 环境下的客户端设置字符集

1.找到路径：C:/Sybase/locales/locales.dat

 

2.用记事本打开该文件:

[NT]

 locale = enu, us_english, iso_1
 locale = fra, french, iso_1
 locale = deu, german, iso_1
 locale = rus, russian, cp1251
 locale = hun, us_english, cp1250
 locale = ell, us_english, cp1253
 locale = heb, us_english, cp1255
 locale = ara, us_english, cp1256
 locale = trk, us_english, cp1254
 locale = esp, spanish, iso_1
 locale = jpn, japanese, sjis
 locale = japanese, japanese, sjis
 locale = chs, chinese, eucgb
 locale = cht, tchinese, big5
 locale = kor, korean, cp949
 locale = us_english.utf8, us_english, utf8
 locale = default, chinese, cp936

 

最后一行的default,设置为:chinese, cp936就是中文字符集了，对ETL工具抽取数据是必须的