DB2 - Problembeschreibung
Problem IC71801 | Status: Geschlossen |
U+FF5E: FULLWIDH TLIDE,U+2015: HORIZONTAL BAR,U+FF0D:FULLWIDTH HYPHEN-MINUS ,U+2225: PARALLEL TO RETURN INCORRECT RESULTS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
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 | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 11.10.2010 09.05.2011 08.02.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP4 | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |