Truncates special characters

[easkra]

Executing next query in PL/SQL developer and SQLPLUS gives different result.
Apparently DOA truncates character 0.
That looks like a bug.

select rpad('acb', 50, chr(0))||'.' as one from dual

 

[ScottMattes]

I tried this and SQL Plus does APPEAR to do it better, but the characters between 'acb' and '.' are x'20' and not x'00'.

 

[easkra]

DOA just should read the value from the database as they are there, but it

 

[Marco Kalter]

The 0 character is indeed an end-of-string indicator (c-style) for PL/SQL Developer. We will fix this in a future release.

 

[easkra]

Not sure if it is PL/SQL Developer problem. It

 

[ScottMattes]

Did anyone note my post about SQL Plus replaces the x0 with a space?

 

[Marco Kalter]

Yes. It's still better than truncating it though.