IDS DB_LOCALE setting
Posted in 2006
Topics: Stored Procedures & SPL, Server Administration, Internationalization & Character Sets
Hi,
I am preparing a site in which i need to provide a functionality 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.