Unicode question

kxlaf · Post by **kxlaf** » Wed 05 Jul 2006 17:16

Hi!
I have an Oracle table in Greek. The database's NLS_CHARACTERSET is WE8MSWIN1252. Computer's locale is Greek. I see perfectly the data in oci mode but not in direct even thow unicode is true. With oratools ican see perfectly the data but if i insert new data i cant see them corect in direct mode.Thanks

Paul · Post by **Paul** » Fri 07 Jul 2006 11:04

In your example Greek Windows location should correspond to EL8MSWIN1253 database charset. Oracle server cannot convert your data to UTF16 (Unicode) correctly. OraTools does not convert strings from EL8MSWIN1253 to WE8MSWIN1252 when you write strings to database in direct mode (It assumes that database charset corresponds to Windows charset in direct mode). OraDirect .NET looks client charset in your Windows settings