IBM Support

Informix server 12.10 xC14 returns an illegal character error when an expression uses a string function and a zero length string

Troubleshooting


Problem

Informix 12.10 returns an illegal character error when an expression uses a string function and a zero length string.

For example, while connected to an  Informix Dynamic 12.10xC14 server version the following will fail
  • select lpad ( '', 1, ' ') from systables where tabid=1
  • select rpad ( '', 1, ' ') from systables where tabid=1
  • select char_length('') from systables where tabid=1
This issue does not in earlier Informix Dynamic Server  12.10 releases such as 12.10xC13.

This issue does not exist in Informix Dynamic Servr 14.10 releases.

Symptom

A SQL statement throws an exception, 202: An illegal character has been found in the statement.

Cause

Informix Dynamic Server
APAR IT32236: LPAD() AND RPAD() ON EMPTY STRING GETTING -202 WHEN USED IN MULTI-BYTE CHARACTER SET DATABASE 

Environment

Informix IDS 12.10 xC14 Enterprise Edition
 
Any version of  the Informix JDBC driver or Informix runtime client

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m0z000000TN4sAAG","label":"Database"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 April 2020

UID

ibm16151749

Page Feedback