Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • Last Modified:

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

0
jazz74
Asked:
jazz74
  • 2
1 Solution
 
sunwellCommented:
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.
0
 
SqueebeeCommented:
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.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now