DB2 - Problem description
Problem IT38969 | Status: Closed |
WRONG STRING COMPARISON FOR THAI NLSCHAR DATABASE COULD HAPPEN | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
In the database created with this codepage and collation NLSCHAR: create db USING CODESET TIS620-1 TERRITORY TH COLLATE USING NLSCHAR Incorrect comparison between char strings could happen. It can also lead to bad order. Indexes could be affected. Please use 'db2dart ' to identify any affected indexes. After this fix is installed all affected indexes need to be recreated. Indexes can also be rebuilt using REORG INDEXES. Example of the problem issue: create table test1 (c1 char(50),c2 char(50)); insert into test1 values ( x'E0202020202020202020202020202020202020202020202020202020202020 20202020202020202020202020202020202020', x'E0FB2020202020202020202020202020202020202020202020202020202020 20202020202020202020202020202020202020' ); insert into test1 values ( x'E0FB2020202020202020202020202020202020202020202020202020202020 20202020202020202020202020202020202020', x'E0202020202020202020202020202020202020202020202020202020202020 20202020202020202020202020202020202020' ); and one see different ordering with c1 and c2: db2 "select hex(c1) from test1 order by c1" 1 ---------------------------------------------------------------- ------------------------------------ E020202020202020202020202020202020202020202020202020202020202020 202020202020202020202020202020202020 E0FB202020202020202020202020202020202020202020202020202020202020 202020202020202020202020202020202020 2 record(s) selected. db2 "select hex(c2) from test1 order by c2" 1 ---------------------------------------------------------------- ------------------------------------ E0FB202020202020202020202020202020202020202020202020202020202020 202020202020202020202020202020202020 E020202020202020202020202020202020202020202020202020202020202020 202020202020202020202020202020202020 2 record(s) selected. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * THAI NLSCHAR DATABASE only * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description, install this fix * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Local Fix: | |
N/A Please, install this fix and re-create indexes affected. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * THAI NLSCHAR DATABASE only * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description, install this fix * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Comment | |
Upgrade to 11.1.4.7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.11.2021 17.04.2022 20.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |