RE: Can not Display Special Characters in informix LVARCHAR

------------------------------------------ Alexey Sonkin > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of kalpana > > Dear All, > We have Informix 9.21 running on Solaris and using Java for > application development. > > At present we have our Database as ISO-8859 we are planning to use > UTF-8 . > I have set up a new database for UTF-8 with the following steps > 1=2EExport the database > 2=2ESet DB_LOCALE to en_us.utf8 > 3=2EDbimport [AS] I suppose, with CLIENT_LOACLE=en_us.utf8 ? > Migration goes fine, if i set both DB_LOCALE & CLIENT_LOCALE to > en_us.utf8 i get errors in data migration bcoz of some characters in > Lvarcar. > > If i set just DB_LOCALE it works fine. [AS] What works fine? > Please if anybody has faced the same problems please let me know the > solution . Is it required to set both locales ? > > My other problem is , we r using Server Studio for sql in client > machine , if i set DB_LOCALE and CLIENT_LOCALE as en_us.utf8 ..it > displays garbage data both in Varchar & Lvarchar. If i try to set it > as EN_US.57372 it doesn't like it. [AS] What 'Server Studio'? AGS Sever Studio? Is it Unicode-enabled? > But if i set Only DB_LOCALE to en_us.utf8 , the data in Varchar is fine > but LVARCHAR again dispaly garbage for characters like "=E9" etc, But if > i check at the OS level data looks fine for insert, update both > existing and new data. > Please advise me what needs to be set for Client machine to display > these characters properly both on Web [AS] Just specify encoding="utf-8" in HTML Doesn't matter what locale - just have DB_ and CLIENT_LOCALE the same as well as Server Studio. Still > our application uses en_US.8859 & we are going to change it to UTF-8. > > > Your help would be highly appreciated as in the new year we have to > migrate to UTF-8. > > Wish you all Merry X-mas and very Happy new year. > Thx in Advance=20 > Kalpana > sending to informix-list