Hebrew encoding in sql server2005
i try this code in sql server 2005
declare @userName nvarchar(50)
set @userName='איש2'
print @userName
bu开发者_如何学Pythont i get this
???2
what is the cause?
it look like it replace the Hebrew char to "?"
10x
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
精彩评论