Hi Christian, I don't know if you can help me on this but I'll try:
I have an Informix DB with a UTF8 encoded database. On connecting I set the DB_LOCALE and CLIENT_LOCALE for connection string as en_US.utf8 and all works perfectly on OS X. With Windows, I get garbled chars when there are UTF8 chars which are not ASCII. Like the euro symbol: € The problem seems Windows natively use the ISOLATIN1 encoding (cp1252). Setting the CLIENT_LOCALE=en_US.819 (ISOLATIN1) Windows starts returning correct chars for all UTF8 chars which can be converted to ISOLATIN1 (like ß) but for other chars (like €) the database server return an error telling the character can't be converted. Which makes sense. However how I can get UTF8 strings on Windows? The DB server works properly and the Mac part too. It could be the Windows Informix driver? Or the SQLAPI++ library? What do you think? Thanks, Massimo Valle SACO Software and Consulting GmbH, Mühlgasse 5, D-97840 Hafenlohr Tel.: ++49 9391 90890-0, Fax: ++49 9391 90890-99, E-Mail: [email protected] Amtsgericht Würzburg HRB 5410, Geschäftsführer: Peter Schubert, Dipl.-Wirt.ing.(FH) Thorsten Beck _______________________________________________ Mbsplugins_monkeybreadsoftware.info mailing list [email protected] https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
