DotNet, Unicode Charcters And Oracle

  • Thread starter Thread starter Ram
  • Start date Start date
R

Ram

Hey,
I'm trying to execute an Insert SQL command, where one of the parameters I'm
trying to insert, has some unicode characters.
The execute command gives no error, but when I use Nevigator to see the new
line,
Alll the unicode characters have been misteryously converted to - "?" !!!
I'v tried every known Oracle Provider - ADO 2.7,
System.Data.Oracle,Oracle.DataAccess (ODP) and OleDB, and had no success...
My Oracle DataBase is 9.2, And I'm using FrameWork 1.1
Please - I need help ASAP!

Thansk ahead

--Ram
 
Ram said:
I'm trying to execute an Insert SQL command, where one of the parameters I'm
trying to insert, has some unicode characters.
The execute command gives no error, but when I use Nevigator to see the new
line,
Alll the unicode characters have been misteryously converted to - "?" !!!
I'v tried every known Oracle Provider - ADO 2.7,
System.Data.Oracle,Oracle.DataAccess (ODP) and OleDB, and had no success...
My Oracle DataBase is 9.2, And I'm using FrameWork 1.1
Please - I need help ASAP!
Click to expand...

How sure are you that the problem is with your insert, and not with the
way you're checking the data?

Have you tried retrieving the data programmatically, and displaying
each unicode value?

Is your insert statement using parameters, or does it contain the data
directly?
 
Also, make sure the database "can take it"
Meaning that fields have to use the "N" version ("NVARCHAR" "NCHAR" etc)
 
Back
Top