Legal characters

Input is composed of the printing characters (bytes 33-255), space (byte 32), horizontal tab (byte 9), line feed (byte 10), and carriage return (byte 13). By default you cannot use the nonprinting control characters.

• Specify the ctrlChars option to allow control characters (bytes 1-8, 11-12, and 14-31) to display within strings. In this case, only 0, 10, and 13 are not allowed.
• Specify the crInString option to allow unescaped carriage returns (cr) in char/varchar fields. If you specify the crlnString option, line feed (LF) becomes the default end-of-row indicator.
• Specify the escapeChar option to allow any character preceded with a backslash (\) to be interpreted as an escape character. In this way, you can use the zero (byte 0), line feed (byte 10), carriage return (byte 13), or the closing delimiter.
• Specify the ignoreZero option to cause the system to check every character for zero. This causes the system to skip over each zero it finds and to consider the next character. If you specify this option, you cannot include a zero byte in a string.
  For example, assume <nul> is a null byte, the field delimiter is '|' and you specified ignoreZero:

     ..|<nul>AB<nul>CDEF<nul>|..

  fills a char(6) column with 'ABCDEF'.

     ..|<nul>127<nul>|..

  fills a byteint column with binary 01111111 (= 0x7F).