|
Problem IT09614
|
Status: Closed |
INCORRECT RESULT COULD BE RETURNED WHEN USING FULLWIDTH UNDER- SCORE CHARACTER (X'EFBCBF') IN LIKE PREDICATE AGAINST CLOB DATA |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Sometimes extra rows that do not qualify might be returned. This
occurs when you use the fullwidth underscore character X'EFBCBF'
in the LIKE predicate to match the CLOB datatype in the CLOB
columns against Unicode databases, and the data's length is less
than the pattern's length. This is because the fullwidth
underscore character is 3 bytes. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users of *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.5 Fix Pack 7 *
**************************************************************** |
| Local Fix: |
Apply this fix or change to use single byte underscore. |
| Solution |
The problem is first fixed in DB2 version 10.5 Fix Pack 7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.06.2015
19.01.2016
27.04.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
