Database Software

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!

Storing chinese characters in database

475941Dec 12 2005 — edited Oct 11 2006

Hello,
I am having problems storing chinese characters into the database. I'm sending it to the database from my .net application using c# on a XP computer. The code to insert it looks like this

string insertquery = "INSERT INTO MyTable (name) Values('',N'" + name+ "')";

I am using an OdbcCommand to insert it. When I view it using the web view of my database it show question marks and when I retrieve the values it actually returns the question marks as the characters. My NLS_CHARACTERSET is WE8MSWIN1252 and my NLS_NCHAR_CHARACTERSET is set to AL32UTF8. I have trying to get this to store for a week now and no luck. I've tried different character sets and still the same problem. I would appreciate any input
regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2006

Added on Dec 12 2005

#database-key-features, #globalization-support

13 comments

11,789 views