I have some problems with the client locale settings.
Posted in 1999
Hoi,
I have some problems with the client locale settings.
I'm using an Informix engine 9.14UC6 on an Unix platform (Sun-Solaris)
When I set the client locale setting on en_us.850 (dos code page) by
using setnet32 for my Informix engine and I execute a query by using the
sqleditor,
I get my results in the correct code page. (databases are stored in code
page en_us.8859-1)
So far no problem.
When I now using JBuilder2.0 and I make a connection to a database ;
url = new String("jdbc:informix-sqli://" + hostname[theServer] +
":" + portnumber[theServer]
+ ":INFORMIXSERVER=" + servername[theServer] + " ;
CLIENT_LOCALE=en_us.850"); this.setConnection(new ConnectionDescriptor(url, aUser, aPasswd,
false, "com.informix.jdbc.IfxDriver"));
I get wrong results in my ResultSet, its always returns me the data in
code page en_us.8859-1, nevertheless I made my connection with code page
en_us.850.
So, did I forgot something or what else is wrong ??
greetings Jan