Hello everybody, I have the following problem regarding storing and retrieving UTF-8 (native .NET String encoding) characters to and from Oracle (8i) database. The special characters (Czech) never get correctly stored in the database nor are the correct values properly displayed when loaded into .NET application. Yet, the Oracle client (i.e. SQL Worksheet) encounters no problem when selecting or inserting(updating) strings containing these characters. Few more details:
1) The database server is running on WE8ISO8859P1 charset (which is ISO- 8859-1 Western European), which cannot be changed (i.e. this is not a solution). 2) In C# I am using OracleClient classes (OracleConnection...), specifically I am using OracleCommand.ExecuteNonQuery to send the data into the database and OracleDataAdapter.Fill method to select the values. I suspect this is due to a bad behaviour of the .NET OracleClient classes. Could somebody help, please? Many thanks Petr Nemec (The special characters are those of Czech) =================================== This list is hosted by DevelopMentor� http://www.develop.com Some .NET courses you may be interested in: Essential .NET: building applications and components with C# November 29 - December 3, in Los Angeles http://www.develop.com/courses/edotnet View archives and manage your subscription(s) at http://discuss.develop.com
