When you convert data between code page 937 and code page 950, the Db2® client uses the
default code page conversion tables. These default code page conversion tables might cause potential
problems when you are converting square brackets ([ ]) and caret (^) characters. An alternate
conversion table is available to correct this issue.
Before you begin
Before you replace the default conversion table file, you
might want to back up the current files. The existing code page is
in the directory sqllib/conv/. The alternate
conversion table 09370950.cnv is in the sqllib/conv/alt directory.
About this task
If you use the default code page conversion table, square brackets and caret characters are
replaced by substitute characters. The default mapping is shown in Table 1.
Table 1. Default mapping
| Code page 937 |
Code page 950 |
| Character |
Code point |
Code point |
Character |
| ¢ |
4A |
5B |
[ |
| ¬ |
5F |
5E |
^ |
| ¦ |
6A |
5D |
] |
| ^ |
B0 |
7F |
SUB |
| [ |
BA |
7F |
SUB |
| ] |
BB |
7F |
SUB |
If you use the alternate code page conversion table, square brackets and caret characters
are mapped to the appropriate code points. The alternate mapping is shown in Table 2.
Table 2. Alternate mapping
| Code page 937 |
Code page 950 |
| Character |
Code point |
Code point |
Character |
| ¢ |
4A |
7F |
SUB |
| ¬ |
5F |
7F |
SUB |
| ¦ |
6A |
7F |
SUB |
| ^ |
B0 |
7F |
^ |
| [ |
BA |
5E |
[ |
| ] |
BB |
5D |
] |
For conversion table replacement to be effective, every
Db2 client that connects
to the same database must have the same conversion table.
Procedure
To replace the Db2 default conversion
table for converting from code page 937 to code page 950:
- When you replace the conversion tables on the client, stop
all the applications that are using the database. If you have any
CLP sessions that are running, issue the TERMINATE command for each
session.
- Copy sqllib/conv/alt/09370950.cnv to sqllib/conv/09370950.cnv.
- Restart all the applications.