Solved

mysql - unicode - japanese language

Posted on 2003-10-29
3
516 Views
Last Modified: 2010-05-18
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
Comment
Question by:jazz74
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
Squeebee earned 125 total points
ID: 9643990
0
 

Expert Comment

by:sunwell
ID: 9675200
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
 
LVL 17

Expert Comment

by:Squeebee
ID: 9817734
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question