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.
No comments:
Post a Comment