Summary:
In some instances, it may be advantages for the DB2 database to be configured so that character data is stored in a binary format in the CCSID 65535 standard. This has the unintended repercussion of the database returning all character data in a binary format, not translated by a code page.
The MicroStrategy ODBC DB2 Wire Protocol Driver can be configured so that the data is converted back to characters transparently with the desired code page that the characters were stored with. The code page specified to do the binary character conversion is specified under the advanced options of the ODBC DSN in the Character Set for CCSID 65535 text field.
The currently valid options for the driver are as follows:
IBM Code Page Number | Value for ODBC Driver Character Set | IANA Name For Code Page
|
37 | 2028 | IBM037 |
38 | 2029 | IBM038 |
290 | 2039 | IBM290 |
300 | 2000000939 | IBM-939(1) |
301(2) | 2000000943 | IBM-943_P14A-2000(1) |
301(3) | 2024 | WINDOWS-31J |
500 | 2044 | IBM500 |
857 | 2047 | IBM857 |
860 | 2048 | IBM860 |
861 | 2049 | IBM861 |
897 | 17 | Shift_JIS |
913 | 6 | ISO_8859-3 |
914 | 7 | ISO_8859-4 |
932 | 17 | Shift_JIS |
939 | 2000000939 | IBM-939(1) |
943(2) | 2000000943 | IBM-943_P14A-2000(1) |
943(3) | 2024 | WINDOWS-31J |
950 | 2026 | Big5 |
1200 | 1015 | UTF-16 |
1208 | 106 | UTF-8 |
1250(2) | 5 | ISO_8859-2 |
1250(3) | 2250 | WINDOWS-1250 |
1251(2) | 8 | ISO_8859-5 |
1251(3) | 2251 | WINDOWS-1251 |
1252(2) | 4 | ISO_8859-1 |
1252(3) | 2252 | WINDOWS-1252 |
1253(2) | 10 | ISO_8859-7 |
1253(3) | 2253 | WINDOWS-1253 |
1254(2) | 12 | ISO_8859-9 |
1254(3) | 2254 | WINDOWS-1254 |
1255(2) | 11 | ISO_8859-8 |
1255(3) | 2255 | WINDOWS-1255 |
1256(2) | 9 | ISO_8859-6 |
1256(3) | 2256 | WINDOWS-1256 |
1257 | 2257 | WINDOWS-1257 |
1258 | 2258 | WINDOWS-1258 |
4396 | 2000004396 | IBM-4396(1) |
5026 | 2000005026 | IBM-5026(1) |
5035 | 2000005035 | IBM-5035(1) |
5297 | 1015 | UTF-16 |
5304 | 106 | UTF-8 |
13488 | 1013 | UTF-16BE |
(1)These values do not appear in http://www.iana.org/assignments/character-sets.
(2) If the application runs on a UNIX or Linux platform, use this value.
(3) If the application runs on a Windows platform, use this value.
Notes: