CODEWITHSUNDEEP
sql-server
happysmile
happysmile

Reputation: 7777

Special character not showing up in select query in SQL Server

I have an question about special characters not showing up in the query 

DECLARE  @varName1 NVARCHAR(500); 
set  @varName1 = 'ÜCŞKUçÖ'
select '''' + @varName1 + ''' As Name1'

These are the Turkish characters. When I run the above query I get this character as S but it should come as Ş

In the database I have this column value as ÜCŞKUçÖ

How can I solve the issue?

Upvotes: 1

Views: 1537

Answers (2)

Ajay
Ajay

Reputation: 6590

DECLARE  @varName1 NVARCHAR(500); 
set  @varName1 = N'ÜCŞKUçÖ'
select @varName1 As Name

For more in details http://technet.microsoft.com/en-us/library/ms180059.aspx

Upvotes: 0

gvee
gvee

Reputation: 17171

You're not actually storing it as a Unicode value...

SET @varname1 = N'ÜCŞKUçÖ';
SELECT @varname1;

Upvotes: 3

Related Questions