DB2 NET SEARCH / 5765F3802 / 970 - DB2

When the customer used double-byte question mark in text-search, 
zero record was returned. On the other hand, he searched with 
single-byte question mark, some records were returned. 
 
example of failing select: 
 
 
select col1,col2 from nsetest where contains(col2,'"dbdbdb? 
"')=1

**************************************************************** 
* USERS AFFECTED:                                              * 
* All supported platforms                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* USING DOUBLE-BYTE QUESTION MARK IN TEXT-SEARCH RETURNS ZERO  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to V97fp4                                            * 
****************************************************************

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
 

When the customer used double-byte question mark in 
text-search, 
 
zero record was returned. On the other hand, he searched with 
 
single-byte question mark, some records were returned. 
 
 
example of failing select: 
 
select col1,col2 from nsetest where contains(col2,'"dbdbdb? 
 
"')=1

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

15.07.2010
28.04.2011
28.04.2011

9.7.FP4