How can I see non-standard characters in MS Access (Stored in SQL Server) correctly

Question

I currently store my string fields in SQL Server as varchar(x). The Database stores records from across the globe, but non standard characters, such as 'glyphics from Asia or Cyrillic Script/Azbuka from Russia appear as '?????????????' question marks.

How can I prevent this from happening and what are the ramifications of changing SQL Server to handle such input.

score 1 · Accepted Answer · edited May 23 '17 at 11:48

1

for Unicode support you have to use :

nvarchar(x)

nchar and nvarchar (Transact-SQL)

nchar [ ( n ) ] - Fixed-length Unicode character data of n characters. n must be a value from 1 through 4,000.

nvarchar [ ( n | max ) ] - Variable-length Unicode character data. ncan be a value from 1 through 4,000.

Also, you can refer:

What is the difference between varchar and nvarchar?

varchar vs nvarchar performance

edited May 23 '17 at 11:48

Community

1
1

answered Oct 09 '12 at 14:31

Kapil Khandelwal

15,958
2
45
52

Thanks, should there be any performance difference, comparing to varchar of the same character length. – aSystemOverload Oct 09 '12 at 14:37
For Unicode support you have to use nvarchar. Check this: http://stackoverflow.com/questions/35366/varchar-vs-nvarchar-performance – Kapil Khandelwal Oct 09 '12 at 14:42

How can I see non-standard characters in MS Access (Stored in SQL Server) correctly

1 Answers1