• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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