CODEWITHSUNDEEP
mysqlsql
jigen Cruz
jigen Cruz

Reputation: 13

Inserting Chinese and Japanese Char in a field with char data type

I just want to ask if its possible to insert Chinese and Japanese character in a sql column with char as its data type.?

I am unable to convert it first since the column contain a lot of data and were use by my other application

Upvotes: 1

Views: 121

Answers (2)

rakeycakey
rakeycakey

Reputation: 23

Working fine for me in sqlfiddle! (Never tried before and not sure on certain schema's)

http://www.sqlfiddle.com/#!9/395a99/1

CREATE TABLE ZOOM(
CHINESE CHAR(20),
JAPANESE CHAR(20));

INSERT INTO ZOOM
VALUES('白白白','平仮名');

Then

SELECT * FROM ZOOM

Gives:

CHINESE JAPANESE
白白白  平仮名

Upvotes: 0

Tah
Tah

Reputation: 1536

Yes, this is possible. Just make sure your character set is correctly set in your database. Here are some references to check out.

MySQL charset
Unicode reference on CJK

SQL Fiddle demo

Upvotes: 1

Related Questions