How can I print this in sql server?

Daxesh Radadiya

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.

Yogesh Sharma

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.

edited at
0

Comments

0 comments
Login to comment

Related

How I Can Merge Mutiple Rows into One in SQL Server

How can I truncate a datetime in SQL Server?

How can I clone an SQL Server database on the same server in SQL Server 2008 Express?

How can I determine installed SQL Server instances and their versions?

How can I insert audio into SQL Server

How can I make a server print a notification as soon as a client connects to it?

How can I disable multithreading in SQL Server?

How can i import a db from SQL Server to Azure db?

How can I create multi level hierarchy in SQL Server

How can I print cPacket?

How can I print this?

How can I add rows dynamically in datatable for SQL Server

How can I print 413284921265094656?

How can I download a batch of XML files from a SQL server?

How can I print to a remote LPD print server, without locally installing CUPS server

How can I select first inserted row in SQL Server?

How can I calculate the required date in SQL Server 2008?

how can i perfom computed columns in Oracle like in SQL Server

How can I write this SQL Server query?

How can i divide two expressions in Microsoft SQL Server

How can I reshape a table in SQL Server?

How can I solve this query in sql server?

How can I ignore the ' character into a SQL Server where clause?

How can I implement IsNull and Isempty together in sql server query

How I can print directly the value from database sql server. I am using VB.NET

How can I print a list?

How can I get the table name in a SQL Server trigger function?

how can i print a response from server using express and fetch?

How can I use sum() value in SQL Server multiple times?

TOP Ranking

HotTag

Archive