Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting Unicode in Oracle

433282Nov 23 2004 — edited Nov 23 2004

Help!
We are moving from Sql Server to Oracle (using Asp.Net) but I can't seem to insert any unicode characters into the Oracle 9 database.
I am using the Oracle Data provider and have downloaded the 8 meg pdf file but can't find anywhere where unicode is inserted normally.
I am trying like this:

insert into james values (2, N'ä¸³')
(using a varchar2 field)

but it just shows as an upsidedown ?. I can't insert unicode using Toad, Enterprise manager and SQL +. I can't even find a tool to insert a unicode character so i can test getting it out!
Was it meant to be this hard using C# Asp.Net?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2004

Added on Nov 23 2004

#general-database-discussions

3 comments

543 views