|
Problem IC71801
|
Status: Closed |
U+FF5E: FULLWIDH TLIDE,U+2015: HORIZONTAL BAR,U+FF0D:FULLWIDTH HYPHEN-MINUS ,U+2225: PARALLEL TO RETURN INCORRECT RESULTS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Shift-JIS Microsoft primary code point
--------- -------------------------------
X'8160' U+FF5E: Fullwidh Tlide
X'815C' U+2015: Horizontal Bar
X'817C' U+FF0D: Fullwidth Hyphen-Minus
X'8161' U+2225: Parallel To
used in search return the incorrect results |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
****************************************************************
* PROBLEM DESCRIPTION: *
****************************************************************
* RECOMMENDATION: *
* Shift-JIS Microsoft primary code point *
* --------- ------------------------------- *
* X'8160' U+FF5E: Fullwidh Tlide *
* X'815C' U+2015: Horizontal Bar *
* X'817C' U+FF0D: Fullwidth Hyphen-Minus *
* X'8161' U+2225: Parallel To *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Customer should upgrade to v9.7 FP4 or later FP which contains
the fix for the above mentioned problem.
The following is applicable only for SJIS database and for the
searches that are used on double byte special characters.
An environment variable is introduced which needs to be manually
set/unset depending on the conversion table in use.
If default conversion table is used , set the following
environment variable before creating the index .
export NSE_SJIS_USE_IBM_UCODE= TRUE
db2set DB2ENVLIST=NSE_SJIS_USE_IBM_UCODE
Restart DB2/NSE
This helps in converting the characters in SJIS format to
UNICODE according to IBM conversion table during update index
process.
The variable should be unset while Microsoft conversion table is
in use. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.10.2010
09.05.2011
08.02.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
