6The Microsoft Japanese Windows Shift-JIS code page is registered as the IBM 6coded character set identifier (CCSID) 943. However, the Shift-JIS code 6page on HP-UX platform is registered as CCSID 5039. CCSID 5039 contains 6characters in the Japanese Industry Standard (JIS) only, and does not have any 6vendor defined character. You can use a DB2 UDB database of CCSID 5039 6on HP-UX to store Shift-JIS characters, but there will be code page conversion 6between CCSID 5039 and CCSID 943. When using Microsoft ODBC 6applications, you might encounter a potential problem when converting data in 6CCSID 5039 to Unicode, due to differences between IBM's code page 6conversion table and Microsoft's code page conversion table.
6The following list of characters, when converted from CCSID 5039 to
6Unicode, will result in different code points depending on which conversion
6table is used (IBM or Microsoft). For these characters, the IBM
6conversion table conforms to the Japanese Industry Standard JISX0208 and
6JISX0221.
6
6Table 2. CCSID 5039 to Unicode code point conversion
| Shift-JIS code point (character name) | IBM primary code point (Unicode name) | Microsoft primary code point (Unicode name) |
|---|---|---|
| X'815C' (EM dash) | U+2014 (EM dash) | U+2015 (Horizontal bar) |
| X'8160' (Wave dash) | U+301C (Wave dash) | U+FF5E (Fullwidth tilde) |
| X'8161' (Double vertical line) | U+2016 (Double vertical line) | U+2225 (Parallel to) |
| X'817C' (Minus sign) | U+2212 (Minus sign) | U+FF0D (Fullwidth hyphen-minus) |
6For example, the character EM dash with the CCSID 5039 code point of 6X'815C' is converted to the Unicode code point U+2014 when using the 6IBM conversion table, but is converted to U+2015 when using the Microsoft 6conversion table. This can create potential problems for Microsoft ODBC 6applications because they would treat U+2014 as an invalid code point. 6To avoid these potential problems, DB2 UDB provides the alternate Microsoft 6conversion table from CCSID 5039 to Unicode, in addition to the default IBM 6conversion table. You need to replace the default IBM conversion table 6with the alternate Microsoft conversion table. Note that the default 6IBM conversion table from Unicode to CCSID 5039 matches the Microsoft 6version.