MySQL automatically converts character sets.

Character sets are converted using Unicode (ucs2).

Thesjischaracter set does not support the conversion of these extension characters.

There are several conversion rules from so-called“SHIFT JIS”to Unicode, and some characters are converted to Unicode differently depending on the conversion rule. MySQL supports only one of these rules (described later).

cp932supports NEC special characters, NEC selected—IBM extended characters, and IBM selected characters.

Somecp932characters have two different code points, both of which convert to the same Unicode code point. When converting from Unicode back tocp932, one of the code points must be selected. For this“round trip conversion,”the rule recommended by Microsoft is used. (Seehttp://support.microsoft.com/kb/170559/EN-US/.)

The conversion rule works like this:

The table shown athttps://msdn.microsoft.com/en-us/goglobal/cc305152.aspxprovides information about the Unicode values ofcp932characters. Forcp932table entries with characters under which a four-digit number appears, the number represents the corresponding Unicode (ucs2) encoding. For table entries with an underlined two-digit value appears, there is a range ofcp932character values that begin with those two digits. Clicking such a table entry takes you to a page that displays the Unicode value for each of thecp932字符begin with those digits.

The following links are of special interest. They correspond to the encodings for the following sets of characters:

cp932supports conversion of user-defined characters in combination witheucjpms, and solves the problems withsjis/ujisconversion. For details, please refer tohttp://www.sljfaq.org/afaq/encodings.html.