|
Problem IT17086
|
Status: Closed |
SELECT WITH LIKE ON A NVARCHAR COLUMN IN A UTF8 DATABASE CAUSES WRONG RESULTS
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
I have a utf8 database e.g. using en_US.utf8 and a base table
with a nvarchar
where an index is defined on it.
export DB_LOCALE=en_US.utf8
#export DB_LOCALE=de_DE.utf8
dbaccess |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of 12.10.xC1 through 12.10.xC7. *
****************************************************************
* PROBLEM DESCRIPTION: *
* A query may give incorrect results under the following *
* conditions: *
* *
* - GL_USEGLU is set to 1 in environment *
* - UTF8 locale is used, e.g. en_US.utf8 *
* - query contains a LIKE or MATCHES predicate on a column *
* that is defined as NVARCHAR(n) *
* - an index exists on the NVARCHAR column *
* - the pattern used in the LIKE/MATCHES predicate has (n-1) *
* characters followed by a wildcard ('%' for LIKE, '*' for *
* MATCHES) *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC8 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.09.2016
09.12.2016
09.12.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC8
|
| Problem solved according to the fixlist(s) of the following version(s) |
