Informix Forum

How to insert japanese char in informix database?

Posted By: PRASHANT VIRPARIYA
Date: Monday, 27 March 2006, at 10:15 a.m.

Hi,

I am preparing a site in which i need to provide a functionalit to user where user can input the data in japanese language. Its a J2EE based application. My database is informix. The problem is..when i keep the encoding of my page to 8859_1, the characters are inserted correctly in database. But I want the encoding of my page to be utf-8. Now, when i change the encoding of my page to utf-8 and insert the text in database, the japanese text inserted becomes '???'. i.e. the characters are corrupted.

I came to know that there is a parameter called DB_LOCALE in informix database which I will have to set to en_US.UTF8. Can anybody help me if this is the correct solution to this problem? If this is the solution, can you please tell me, where and how do i make this change in database?

When I access my database using dbaccess and go to database->info->Nls, it displys
en_US.819 Collating Sequence
en_US.819 CType

Can anybody please throw some light on this? Appriciate your help. This is bit urgent.

Regards,
Prashant.

Messages In This Thread

• How to insert japanese char in informix database?
  PRASHANT VIRPARIYA -- Monday, 27 March 2006, at 10:15 a.m.
  • Re: How to insert japanese char in informix databa
    PANCHATCHARAM VEERASEKAR -- Sunday, 27 May 2007, at 10:51 p.m.

Informix Forum is maintained by Administrator with WebBBS 5.12.