Skip to Content
0
Former Member
Jun 27, 2006 at 12:04 PM

HOW TO INSERT JAPANESE CHARACTER INTO TABLES

347 Views

i have an dept table

CREATE TABLE DEPT

(

DEPTNO FIXED(2),

DNAME VARCHAR(15) unicode,

LOC VARCHAR(15)

)

now i want to insert data in japanese like

INSERT INTO DEPT VALUES(10,'漢字','LONDON')

it inserted the data successfully,but instead of storing japanese it simply stores the ??

my database is set to Unicode & mapcharset is also set to unicode

but i am not able to insert japanese characters.

please help me out..

thanx in advance..