IT27575: SELECT WITH LIKE ON A NVARCHAR COLUMN IN A UTF8 DATABASE CAUSES WRONG RESULTS

APAR status

• Closed as fixed if next.

Error 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 << EOF
  drop database test;
  create database test;
  CREATE TABLE testlike (  str NVARCHAR(10));
  CREATE INDEX xpktestlike ON testlike ( str );
  INSERT INTO testlike VALUES ('1234567890');
  EOF
  
  When I use the following query
  
  select str from testlike WHERE str like '123456789%';
  
  no rows are returned.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IDS 11.70.xC9 and 12.10.xC9 and earlier versions.   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Select with like on a nvarchar column in an utf8 database    *
  * cause wrong results.                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels