title: Bulk insert not recognizing row terminators
body: <p>I'm preparing format files to import text-qualified files into sql-server based on <a href="https://blogs.msdn.microsoft.com/sqlserverfaq/2010/02/04/how-to-remove-unwanted-quotation-marks-while-importing-a-data-file/" rel="nofollow noreferrer">This article</a></p>
  
  <p>Sample of data for import:</p>
  
  <pre><code>"1000000"|"1100000"|"2017-02-26 00:00:00"|"CAT1"|"Item from CAT1"
  "1000001"|"1100000"|"2017-02-26 00:00:01"|"CAT2"|"Item from CAT2"
  "1000002"|"1100001"|"2017-02-26 00:01:02"|"CAT2"|"Item from CAT2"
  "1000003"|"1100002"|"2017-02-26 01:02:03"|"CAT3"|"Item from CAT3"
  </code></pre>
  
  <p>My format file:</p>
  
  <pre><code>13.0
  6
  1       SQLCHAR             0       0       "\""        0     FIRST_QUOTE                     SQL_Latin1_General_CP1_CI_AS
  2       SQLINT              0       4       "\"|\""     1     transaction_id                  ""
  3       SQLINT              1       4       "\"|\""     2     user_id                         ""
  4       SQLDATETIME         0       8       "\"|\""     3     create_date                     ""
  5       SQLCHAR             2       10      "\"|\""     4     category                        SQL_Latin1_General_CP1_CI_AS
  6       SQLCHAR             2       50      "\"\r\n"    5     item                            SQL_Latin1_General_CP1_CI_AS
  </code></pre>
  
  <p>Which results in:</p>
  
  <blockquote>
    <p>The bulk load failed. The column is too long in the data file for row 1, column 6. Verify that the field terminator and row terminator are specified correctly.</p>
  </blockquote>
  
  <p>I'm fairly certain that file contains \r\n (Checked with Hex editor shows 0x0d,0x0a), although ignoring text qualifiers and format file i was able to import it manually only with</p>
  
  <pre><code>Bulk insert &lt;table_name&gt; from '\\path\to\file' with (fieldterminator='|', rowterminator='\n')
  </code></pre>