Unicode question

Unicode question

Postby 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
kxlaf
 
Posts: 2
Joined: Wed 05 Jul 2006 17:09

Postby 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
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle