PL/SQL ignores ASCII null characters

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?

    Requires Free Membership to View

    Login

Try using chr(32). Chr(32) equals a space.

For example: 

select 'ABC' ||chr(32)||chr(32)||'DEF' from dual

Result: 'ABC DEF'

This was first published in August 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top