I am trying to send an escape sequence to a dot matrix printer. But the sequence has embedded ASCII null characters (i.e., chr(0)), and PL/SQL seems to ignore the first null and all sequence bytes after. Why is this and what is the workaround?
Try using chr(32). Chr(32) equals a space.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
select 'ABC' ||chr(32)||chr(32)||'DEF' from dual
Result: 'ABC DEF'