Today, when I used SQL Server Management Studio to connect to SQL Server 2008 R2, I noticed that Chinese Characters in one table column could not be displayed correctly on my Windows 7 machine. It showed Garbled Characters. I added Collation in SQL Query and it didn’t work either.
After looking into this interesting issue, I noticed that for some reason, language packs were not installed. After installing Chinese language packs successfully and rebooting the machine, the Chinese data is displayed well in SQL Server 2008 R2.