Hi everyone,
I am tried to store Chinese character in my Database, it worked using nls character set.it stored as ?? . this should be fine.But when i tried to retrieve the data it showing like ?? only. but i want to see as a Chinese character. is this possible using sql query or in some other way? Please help me in this.
Chinese character i have stored - 杏仁
create table unicode(chin varchar(100 char));
insert into unicode (chin) values (N'??' );
1 row inserted
SELECT * FROM unicode;
chin
--------
??
Thanks in advance,
Su