T T-Gergely Member³ Aug 8, 2012 #1 PD truncates strings at chr(0) while Sql*Plus does not. CREATE TABLE bug0 (a VARCHAR2(2000)); INSERT INTO bug0 VALUES ('123'||CHR(0)||'456'); SELECT * FROM bug0;
PD truncates strings at chr(0) while Sql*Plus does not. CREATE TABLE bug0 (a VARCHAR2(2000)); INSERT INTO bug0 VALUES ('123'||CHR(0)||'456'); SELECT * FROM bug0;
Marco Kalter Administrator Staff member Aug 9, 2012 #1 This is indeed a known limitation. Varchar2 is fetched as c-style zero-terminated strings, so chr(0) is interpreted as the end of the string.
This is indeed a known limitation. Varchar2 is fetched as c-style zero-terminated strings, so chr(0) is interpreted as the end of the string.
