When using SJIS charset, there is a problem when the second byte of
a character matches with 7bit ASCII code.
The character codes including \(\x5C) in their second byte need
caution.
The range of SJIS code is [\x81-\x9F\xE0-\xFC][\x40-\x7E\x80-\xFC]
Please see my test result at
http://epx.timedia.co.jp/mysql/sjis-2ndbyte_html
The problem was solved when I set sjis to launch mysql client command
mysql --default-character-set=sjis
or in my.cnf
[mysql]
default-character-set = sjis
Without above setting, MySQL didn't handle the character correctly
even if I typed the following settings:
set names sjis
set character set sjis
This is the explanation in the English manual:
-----------------------------------------------------------------------
http://dev.mysql.com/doc/mysql/en/Character_sets.html
5.7.1 The Character Set Used for Data and Sorting
You can force the client to use specific character set as
follows:
[client]
default-character-set=character-set-name
This is normally unnecessary, however.
-----------------------------------------------------------------------
But it seems that I have to set this option to use SJIS character set.
------------------------------------------------------------
Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World
[EMAIL PROTECTED] http://www.pro.or.jp/~fuji/index-eng.html
[EMAIL PROTECTED] Puzzle Japan http://www.puzzle.jp/
------------------------------------------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
