CRinString option

Specifies whether to allow unescaped carriage returns in char, varchar, nchar, and nvarchar fields.

Acceptable values are as follows:
  • true or false
  • on or off
Do not put quotation marks around the value. The default value is false; in this case and in the case of off, all CR or CRLF control characters are treated as end of record. If the value is true or on, unescaped CR control characters are accepted in char and varchar fields (the LF control character becomes only end of row).

This option has a different behavior for the fixed-length format. For information, see Changes in option behavior for the fixed-length format.