Insert utf8 record to oracle db (c#)
829866Jan 11 2011 — edited Jan 12 2011hi guys,
i'm using oracle 10g, and oracleclient with c#,
and trying to insert an utf8 record into my db, the problem is everything becomes "¿"
i'm sure that my db is utf8 by this query:
select value from nls_database_parameters where parameter='NLS_CHARACTERSET';
my db query is like this:
------------------------------------------
insert into my_table (name,email) values ('Николай','someone@example.com');
------------------------------
but after doing the query, what i see in the db is all "¿¿¿¿¿¿......
(i'm using Toad for Oracle to see db, Toad showing fine all other utf records)
please help