470,595 Members | 1,547 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,595 developers. It's quick & easy.

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
Nov 16 '05 #1
2 4679
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
Nov 16 '05 #2
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
Nov 16 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by ..... | last post: by
2 posts views Thread by Ram | last post: by
24 posts views Thread by ChaosKCW | last post: by
8 posts views Thread by Richard Schulman | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.