– How to configure MySQL for Japanese?
If you just need to store the Japanese data (no sorting, no SQL operation using 'LIKE'.. ), you don't need to configure my.ini or my.cnf. (“character_set latin1 ” is OK.)
if you need specific configuration,
see
Tomita Masahiro's page(Autor of Japanese patch, English)
His detailed explanation(Machine Translation Via Excite.co.jp)
– How to display Japanese in Windows when your default language is English?
I'm not sure whether English Windows(And IE or FireFox) can display Japanese Characters without installing any softwares. But my IE6 in Japanese Windows XP can display Chinese, Korean or Thai …. without installing any fonts or software.
If you want to write (input ) Japanese Characters, you can make use of
Global IME you can download freely from Microsoft.
– CREATE TABLE SQL for a sample table
See the attached “test.sql”. I stored Japanese Numbers(1234567890 in large letters) and Days of the week in three encodings. (UJIS, SJIS, UTF-8).
The image is:
[img]http://hp.vector.co.jp/authors/VA035840/temp/code_test2.PNG[/img]
SQLyog's display:
[img]http://hp.vector.co.jp/authors/VA035840/temp/SQLyog.PNG[/img]
If SQLyog has an “encoding feature” similar to IE (for example), then it will be great!
(Is RichText Control suitable?)
