Hi all,

I'm new user for Informix DB, now I want to setup a Informix 10 database which character set is not English, like Unicode, Big5 ..., the OS is Windows XP with Multi-language, English locale.

I did following to setup my database after install Informix 10 software:
1. create a new server instance with all default options using the tool Server Instance Manager. server name is in10utf8.
2. update the inf10utf8.cmd to change the Client_locale and DB_locale from EN_US.CP1252 to EN_US.UTF8, below is the contain in inf10utf8.cmd:
set INFORMIXDIR=C:\PROGRA~1\Informix
set INFORMIXSERVER=inf10utf8
set ONCONFIG=ONCONFIG.inf10utf8
set PATH=C:\PROGRA~1\Informix\bin;%PATH%
set CLASSPATH=%INFORMIXDIR%\extend\krakatoa\krakatoa.j ar;%INFORMIXDIR%\extend\krakatoa\jdbc.jar;%CLASSPA TH%
set DBTEMP=C:\PROGRA~1\Informix\infxtmp
set CLIENT_LOCALE=EN_US.UTF8
set DB_LOCALE=EN_US.UTF8
set SERVER_LOCALE=EN_US.CP1252
set DBLANG=EN_US.CP1252
mode con codepage select=1252
3. run inf10utf8.cmd, execute dbaccess, then create database.

Above three steps are correct to setup Unicode database? if I want to create other charset database, if only change the Client_locale and DB_locale to accordant code set?

Thanks very much!
Frank