Hi All,

We have informix 9.21 UC2 running on solaris.

We want to change the database code set from default (ISO8859-1)
to UTF-8 . I have few questions reg this.

1. Do i need to set both CLIENT_LOCALE and DB_LOCALE in the server
before
dbimport? Developer is telling he will set the code set to UTF-8 in
appln and browser , do i still need to set CLIENT_LOCALE ?

2. Do i need to set at the client application aslo as UTF-8?

3. Is there any effect if i don't change SERVER_LOCALE?

4. I am just trying on testing box ,
i have updated the systables
Update systables set site ='en_US.UTF-8' where tabid in(90,91);
and did import the database.
Now neither i can drop the database nor i can use it .. ..
Later i gone through the GLS directoryand i found that instead of
en_US.UTF-8 it is en_us.utf8 i changed to same . Even after that same
problem..

But in the sysdbslocale it shows en_US.819 and systables shows
en_US.57372.

Please suggest how to drop such database as i do not more disk space.
It is highly appreciated.

5. I have created another database with utf8 it is working fine ...but
if i give command env in unix it does not show DB_LOCALE..
Do i need to set this as permanent env variable ? Please advise me
your help is highly appreciated.

Regards
Kpai