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.
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"}}]
Was this topic helpful?
Document Information
Modified date:
06 April 2020
UID
ibm16151749