Petr,
Try loading the Oracle client and using their .Net provider.
Robert
At 12:00 AM 11/19/2004 -0500, you wrote:
Date: Thu, 18 Nov 2004 11:29:01 -0500 From: Petr Nemec <[EMAIL PROTECTED]> Subject: Problem with storing and retrieving special characters over OracleClient classes
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
=================================== 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
