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

Question

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();

Vulpes · Answer

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 abubakr · Answer

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?

Vulpes · Answer

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 abubakr · Answer

ok thank you ... but my problem not with first column its a code you are right .. my problem with the dept_name column?

Vulpes · Answer

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();