Informix - Problem description
Problem IT17633 | Status: Closed |
LPAD() FUNCTION RETURNS INCORRECT STRING IN MULTI-BYTE ENVIROMENT | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
Regarding lpad() function, the manual states that that the 'length' is specified for total number of bytes in the returned string but in multi-byte locale environments, the returned string is determined according the the number of logical characters. - http://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com .ibm.sqls.doc/ids_sqs_1563.htm LPAD Function The LPAD function returns a copy of source_string that is left-padded to the total number of bytes specified by length. | length Integer value that specifies total number of bytes in the returned string | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Informix 11.70, 12.10 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * See Problem Conclusion * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.10.2016 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |