CODEWITHSUNDEEP
sqlsql-serversql-server-2008sql-server-2008-r2
user2881809
user2881809

Reputation:

Wrong encoding display data in Microsoft SQL Server Management Studio

I'm sorry if answer on this question already exist, but I couldn't find it

Please give me a link if answer already exist.

I use SQL Server 2008 R2.

When I run a select in Microsoft SQL Server Management Studio like this:

SELECT * 
FROM Firm COLLATE SQL_Latin1_General_Cp1251_CI_AS

I get wrong encoding display data in Microsoft SQL Server Management Studio:

wrong encoding display data in Microsoft SQL Managament Studio

Tell me please how make that data show in the correct coding?

Upvotes: 1

Views: 1308

Answers (1)

Sandr
Sandr

Reputation: 776

The problem is not with stored data (otherwise the "?" symbols will be returned). Looks like the problem with fonts in the SQL Server management studio. Check the settings in the menu item

Tools => Options => Environment => Fonts and Colors (section Grid Results):

enter image description here

Upvotes: 2

Related Questions