title: Wrong encoding display data in Microsoft SQL Server Management Studio
body: <p><em>I'm sorry if answer on this question already exist, but I couldn't find it</em></p>
  
  <p><em>Please give me a link if answer already exist.</em></p>
  
  <p>I use SQL Server 2008 R2.</p>
  
  <p>When I run a <code>select</code> in Microsoft SQL Server Management Studio like this:</p>
  
  <pre><code>SELECT * 
  FROM Firm COLLATE SQL_Latin1_General_Cp1251_CI_AS
  </code></pre>
  
  <p>I get wrong encoding display data in Microsoft SQL Server Management Studio:</p>
  
  <p><img src="https://i.stack.imgur.com/XxBtv.png" alt="wrong encoding display data in Microsoft SQL Managament Studio"></p>
  
  <p>Tell me please how make that data show in the correct coding?</p>