IC56579: APPLICATION WITH OLEDB PROVIDER ABENDS IF AN SQL STATEMENT CONTAINS A 0X8D86 MULTI BYTE CHARACTER

APAR status

• Closed as program error.

Error description

• An application with an oledb provider abends if an sql
  statement contains an 0x8d86 multi byte character which is part
  of the SJIS locale. The problem does not reproduce using a .NET
  provider or ODBC.
  For Example:
  var objADO = new ActiveXObject("ADODB.Connection");
  objADO.Open("provider=ifxoledbc.2;Data
  Source=oledb@server;DB_LOCALE=ja_jp.ujis;CLIENT_LOCALE=ja_jp.sj
  is-s; User ID=informix; password=00informix;");
  var objRS = objADO.Execute("select num, name from testtbl
  where name ='0x8d86 code is placed in here' ");
  WScript.echo("objADO.Execute")
  if ( objRS.Eof ) {
      WScript.echo("data not found");
  }else {
      WScript.echo(objRS("num"));
      WScript.echo(objRS("name"));
  }
  objRS.Close()
  objADO.Close()
  objRS = null;
  objADO = null;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users using the CSDK-OLEDB component on Windows for the      *
  * japanese locale ONLY has this issue.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The problem occurs for a vey specific japanses character.    *
  * The query involving this special japanses character throws   *
  * an error.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * To obtain this fix, the user shall need to upgrade to CSDK   *
  * 3.50 xC5 fix pack.                                           *
  ****************************************************************
  

Problem conclusion

• The problem was with incorrect function implementation. This has
  now been corrected. The fix shall be available in CSDK 3.50 xC5.
  

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

• Fixed component name

  INFORMIX CLIENT

• Fixed component ID

  5724C2300

Applicable component levels

• R290 PSN

     UP