inserting unicode data from c# form to oracle 11g?

honar abubakr

when i want to insert some unicode data from c# form to oracle 11g EX ... in oracle the data like this '????????' but when i want to insert unicode data from oracle command it does not have any problem.
insert into depts values (8,'?????')
it does not have a problem (oracle sql command) but in c# i use

com.CommandText = "insert into DEPTS values('"+dept_cod_txt.Text+"','"+dept_name_txt.Text+"')"; com.ExecuteNonQuery();

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Hmm, on the face of it, I'd expect it to work if you're inserting non-ASCII characters in an nvarchar2 column.

If you haven't done it already, try inserting: Unicode=True in your connection string.
honar abubakr12y ago
yes that is my problem after insertion the data in oracle is like this '???????'
at first my dept_name column datatype was varchar2 ... i changed it to nvarchar2 ... still i have the same problem?
Vulpes12y ago
Sorry, I'm not clear what the problem is.

Are you saying that, after the insertion, the dept_name column in the Oracle table is not showing the correct value?

If not, what is the data type of that column?
honar abubakr12y ago
ok thank you ... but my problem not with first column its a code you are right .. my problem with the dept_name column?
Vulpes12y ago
The first column appears to be an integer and so you don't want to surround it with single quotes:

com.CommandText = "insert into DEPTS values("+dept_cod_txt.Text+",'"+dept_name_txt.Text+"')";
com.ExecuteNonQuery();