Link to home
Start Free TrialLog in
Avatar of jazz74
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

ASKER CERTIFIED SOLUTION
Avatar of Squeebee
Squeebee
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sunwell
sunwell

I think if you never convert the charset in the database. and do it in your program, it is ok.
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.
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.