title: How to retrieve German characters from a large CSV File into SQL Server 2017 script
body: <p>I have a CSV file including a list of employees, where some of them includes German characters like 'ö' in their names. I need to create a temp table in my SQL Server 2017 script and fill it with the content of the CSV file. My script is:</p>
  <pre><code>CREATE TABLE #AllAdUsers(
      [PhysicalDeliveryOfficeName] [NVARCHAR](255) NULL,
      [Name] [NVARCHAR](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [DisplayName] [NVARCHAR](255) NULL,
      [Company] [NVARCHAR](255) NULL,
      [SAMAccountName] [NVARCHAR](255) NULL
  )
  
  --import AD users
  BULK INSERT #AllAdUsers
      FROM 'C:\Employees.csv'
      WITH
      (
          FIRSTROW = 2,
          FIELDTERMINATOR = ',',  --CSV field delimiter
          ROWTERMINATOR = '\n',   --Use to shift the control to next row
          TABLOCK
      )
  </code></pre>
  <p>However, even though I use &quot;Nvarchar&quot; variable type with the collation of &quot;SQL_Latin1_General_CP1_CI&quot;, the German characters are not seem OK, for instance &quot;Kösker&quot; seems like:</p>
  <pre><code>&quot;K├╢sker&quot;
  </code></pre>
  <p>I've tried many other collations but couldn't find a fix for it. Any help would be very much appreciated.</p>