Oracle client in windows 2008R2 64 bit convert composite characters (accentuated vowel) to simple on
Hello,
We're trying to get composited characters (à, é, ü ...) from a SQLPlus on a Windows 2008R2 64 bit this worked fine in windows2003 32bit.
It seems "oracle client" transform text data changing composed text to simple ones, so you see an _a_ and not an _à_ or a unreadable simbol.
Diagnostics we tried: SQLNet trace, tcpdump a " select dump(_column_) from BBDD.TABLE where rownum=1" , in all here case we receive an "OE (hexa)", "224 dec" code for an _à_ but on output file (or printed on SQLPLUS) it shows as an "61 (hexa)" or an "97 (dec)" .
Also ODBC driver also present this anoying (and unexpected) character conversion.
We're trying to get composited characters (à, é, ü ...) from a SQLPlus on a Windows 2008R2 64 bit this worked fine in windows2003 32bit.
It seems "oracle client" transform text data changing composed text to simple ones, so you see an _a_ and not an _à_ or a unreadable simbol.
Diagnostics we tried: SQLNet trace, tcpdump a " select dump(_column_) from BBDD.TABLE where rownum=1" , in all here case we receive an "OE (hexa)", "224 dec" code for an _à_ but on output file (or printed on SQLPLUS) it shows as an "61 (hexa)" or an "97 (dec)" .
Also ODBC driver also present this anoying (and unexpected) character conversion.
0