title: SQL Server Bulk Import - character translation?
body: <p>I have a pipe delimited text file I am using BULK INSERT to import into a table in SQL Server.</p>
  
  <p>I have had real problems with certain characters. For example, text that appears in the text file as "30º of tilt and 80º" gets imported as "30┬║ of tilt and 80┬║"</p>
  
  <p>Now, the data in the text file was actually generated from another SQL Server database, and in the original table the string appears as "30º of tilt and 80º" so I'm somewhat baffled.</p>
  
  <p>Both databases have the same collation. The SP I use to do the bulk insert is:</p>
  
  <pre><code>DECLARE @sql nvarchar(4000) = 'BULK INSERT ' + @TempTable + ' FROM '''+@Sourcefile+''' WITH (FIELDTERMINATOR=''|'',ROWTERMINATOR=''\n'');'
  EXEC(@sql)
  </code></pre>
  
  <p>Which works fine in all other respects</p>
  
  <p>Thanks</p>