Solved

mysql - unicode - japanese language

Posted on 2003-10-29
3
515 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
Comment Utility
0
 

Expert Comment

by:sunwell
Comment Utility
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
Comment Utility
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

728 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now