jazz74
asked on
mysql - unicode - japanese language
I read that mysql 4.1 supports unicode:
http://www.mysql.com/doc/en/Charset-Unicode-sets.html
so i guess i can now store data in japanese language without any problem, but i'm not sure.. so i have a simlpe table:
create table news (
id_news int(10) not null auto_increment,
id_language char(2) not null,
title varchar(255) not null,
abstract text not null,
image_file varchar(200),
primary key (id_news))
type=MyISAM;
id_language could be 'en' or 'jp' [or other..], how can i store informations for these different language? I'm working on linux (maybe red-hat 9), apache, php and, obviously, mysql.
thanks in advance
http://www.mysql.com/doc/en/Charset-Unicode-sets.html
so i guess i can now store data in japanese language without any problem, but i'm not sure.. so i have a simlpe table:
create table news (
id_news int(10) not null auto_increment,
id_language char(2) not null,
title varchar(255) not null,
abstract text not null,
image_file varchar(200),
primary key (id_news))
type=MyISAM;
id_language could be 'en' or 'jp' [or other..], how can i store informations for these different language? I'm working on linux (maybe red-hat 9), apache, php and, obviously, mysql.
thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just to answer your comment sunwell: While that may work you would lose a lot of mysql functionality, as you could not use search and string processing functions properly, as you could with the proper character set defined.
because I can see the chinese language( similar to japanese) in my english windows xp.
and the mysql charset was not changed. Only I do was installed the asian language supported in xp.
Then I can see the chinese in mysql front correctly.