The output window is filled with '?' marks.
select ('все магазины Сильпо') as test
I want the exact same text in the output window. I am using SQL Server 2016.
Add N
prefix to identify unicode
character :
SELECT N'все магазины Сильпо' AS test
N
actually stands for National language character set.
To quote from Microsoft:
Prefix Unicode character string constants with the letter N. Without the N prefix, the string is converted to the default code page of the database. This default code page may not recognize certain characters.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments