|
Problem IT08235
|
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 / A10 - 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 Unicode databases *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.1.0.5. *
**************************************************************** |
| Local Fix: |
Apply this fix or change to use single byte underscore. |
| Solution |
The problem is first fixed in DB2 version 10.1.0.5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.04.2015
10.07.2015
10.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
