title: SQL Server: Error to import data with umlauts and special characters
body: <p>I am trying to import this data <a href="https://pxnet2.stat.fi/PXWeb/pxweb/fi/Kuntien_avainluvut/Kuntien_avainluvut__2017/kuntien_avainluvut_2017_aikasarja.px/?rxid=444223df-f91c-4479-891f-5dcd50b983d2" rel="nofollow noreferrer">here</a> with special characters such as <code>ä</code> and <code>ö</code> (umlauts). When I import data in SQL Server Management Studio, I get the following error</p>
  <blockquote>
  <p><a href="https://i.stack.imgur.com/FpeQK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FpeQK.png" alt="enter image description here" /></a></p>
  <p><code>The output char buffer is too small to contain the decoded characters, encoding 'Unicode (UTF-9)'fallback 'System.Text.DecoderReplacementFallback'. Parameter name: chars (mscorlib)</code></p>
  </blockquote>
  <p>so how can I import the data with umlauts to SSMS? What is causing the error and how to overcome it?</p>