Hebrew encoding in sql server2005

Question

i try this code in sql server 2005

declare @userName nvarchar(50)
set @userName='איש2'    
print @userName

but i get this

???2

what is the cause?

it look like it replace the Hebrew char to "?"

10x

Answer 1

Use the N prefix so the string literal is interpreted as unicode not char under the code page of whatever your database's default collation is

declare @userName nvarchar(50)
set @userName=N'איש2'    
print @userName