DotNet, Unicode Charcters And Oracle

[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

[Jon Skeet [C# MVP]]

Ram <ni***@bezeqint.net> wrote:

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!

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?

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Mihai N.]

Jon Skeet [C# MVP] <sk***@pobox.com> wrote in
news:MP************************@msnews.microsoft.c om:

Ram <ni***@bezeqint.net> wrote:

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!

Also, make sure the database "can take it"
Meaning that fields have to use the "N" version ("NVARCHAR" "NCHAR" etc)

--
Mihai
-------------------------
Replace _year_ with _ to get the real email