Unicode question

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 2
Joined: Wed 05 Jul 2006 17:09

Unicode question

Post by kxlaf » Wed 05 Jul 2006 17:16

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

Posts: 725
Joined: Thu 28 Oct 2004 14:06

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

Post Reply