title: Polish encoding in Microsoft Sql Server
body: <p>I have a problem with characters encoding in my ms sql server (version Enterprise 2014). I create bulk files via c# program, bulk are encoded in UTF-8 with polish characters, but when I insert bulk into my database instead of strings with polish characters I have strings with default ASCII characters.</p>
  <p>Here is my create table declaration:</p>
  <pre><code>create table Klient
  (
      imie varchar(20),
      nazwisko varchar(40),
      id int identity(1,1),
      primary key (id),
  )
  </code></pre>
  <p>Here is a part of my bulk file:</p>
  <pre><code>...
  Sylwiusz|Okyne|1
  Adolf|Osientowicz|2
  Jagoda|Chołyś|3
  Wanda|Peryhasza|4
  Milena|Czybieniak|5
  Katarzyna|Czarnopyś|6
  Witomir|Chałubowicz|7
  Rut|Garuz|8
  Rut|Sciolny|9
  Klementyna|Leszer|10
  Lucjusz|Boralciewicz|11
  ...
  </code></pre>
  <p>Here is a script which push bulk to the database:</p>
  <pre><code>BULK INSERT Klient FROM 'src' WITH (KEEPIDENTITY, FIELDTERMINATOR='|', ROWTERMINATOR = '\n');
  </code></pre>
  <p>Here is my database properties:
  <img src="https://i.stack.imgur.com/PW1D1.png" alt="enter image description here" /></p>
  <p>Here is properties of column which has string with polish characters:
  <img src="https://i.stack.imgur.com/vfHPb.png" alt="enter image description here" /></p>
  <p>And here is what it looks into my database:</p>
  <p><img src="https://i.stack.imgur.com/Qobri.png" alt="enter image description here" /></p>
  <p>I also try using nvarchar instead of varchar but it didn't help for me. Maybe I should use another collation? But I don't have idea which one because there is about 30-40 polish collations.. So if someone could help me I will be very grateful!</p>
  <h1>EDIT</h1>
  <p>Regarding to @Giorgios answer adding codepage=&quot;65001&quot; didn't help for me because sql server returns info that he isn't support it. I also find info that sql server never support codepage 65001, but it's a <a href="http://connect.microsoft.com/SQLServer/feedback/details/370419" rel="nofollow noreferrer">info</a> from 2009, but I don't know if it's actual with sql server 2014..</p>