Encoding issues with Instant Client and Win-1252 database
618236Jan 17 2008 — edited Jan 23 2008Hi,
I'm connecting to a Win-1252-encoded Oracle XE database from a Ruby on Rails application via ruby-oci8.
NLS_CHARACTERSET WE8MSWIN1252
NLS_NCHAR_CHARACTERSET AL16UTF16
When the database and the application reside on the same physical server, the application retrieves the correct characters from the tables. But if the database resides on a different machine, then I use Oracle Instant Client; unfortunately the characters I get back from the database are then incorrect ('e' instead of 'é', 'a' instead of 'à', etc.).
Is there some kind of setting (or another version of the Instant Client) that I can use to fix this encoding problem?
Thanks,
Chris.