Null character in varchar2 columns are not ignored

MarkvU

Member
Hello,

Al colleague of mine drew my attention to the following curiousity. If in a varchar2 column there is a null-character (chr(0)) somewhere in the middle, then the SQL-grid truncates this varchar2 colum.

I would expect PL/SQL Developer to ignore these characters, maybe substitute them with a newline or something, but to truncate it seems like the wrong thing right?

From my perspective this is a bug, is there anywhere that I can have this registered as a bug?

Regards,
Mark van Uden - an otherwise very happy PL/SQL Developer user
 
Back
Top