Can't anybody help to figure out what i'm doing wrong:
I have Informix SE database with DB_LOCALE = ru_ru.915
Connecting to it from windows using JDBC 3.50 JC5, connection code is: Properties prop=new Properties();
String url = "jdbc:informix-sqli://192.168.0.1:1526/mydb:informixserver=srv_remote";
conn = DriverManager.getConnection(url, prop);
Connection is ok, and i can select data. But all character data is in ISO-8859-5 (915) encoding(i'm converting it localy from ISO to UTF and see correct strings...). I tried to change DB_LOCALE & CLIENT_LOCALE to other locales - nothing happens...
About engines...on Informix SE i have nothing to start except sqlexecd for remote connection. I tried to start sqlexecd with various server LOCALE environment variables but without any changes to character set on remote side...
ok, well this is going to sound awkward and antiquated, but this is what I do when I start my INFORMIX-SQL version 2.10 (SE-engine) on DOS.
set DBLOCALE= ????
are you setting your environment variables before firing-up SE?
refer to the GL language support section of the INFORMIX reference manual,
it gives you detail instructions for setting up the locale.
It includes telling informix where to look for the message files, eyc.