SQL Server displays ??? instead of Unicode characters

Question

I run SQL Server 2008 Express on my Windows 8.1. After inserting some Unicode characters in Database, characters are not displayed properly (the data has no problem just displayed improperly). Manually inserting the values using 'Management Studio' will lead to the same result. I typed information in Persian Language and installed persial Language pack for Windows 8.1 however this does not fixed anything. enter image description here
Am I missed something in SQL Server options? The same configuration on windows 7 have no problems.

score 4 · Accepted Answer · edited May 23 '17 at 12:21

4

Check if your field is UNICODE (nchar or nvarchar).
Check collation for your database.
Make sure your UNICODE literals have N prefix.

UPDATE: check this, possible duplicate question

edited May 23 '17 at 12:21

Community

1
1

answered Mar 14 '14 at 16:13

Kenan Zahirovic

1,587
14
24

VSB · Answer 2 · 2014-03-14T17:39:43.640

0

Changing type of fields from VARCHAR to NVARCHAR fixes the problem but it does not recover data stored in bad format.

edited Mar 14 '14 at 17:39

answered Mar 14 '14 at 16:49

VSB

9,825
16
72
145

SQL Server displays ??? instead of Unicode characters

2 Answers2