using unicode text in sql server 2008

Question

I want to use unicode text in my site. I have nvarchar(max) data type in database to store the data. When I save unicode text into database, it works fine. However when i try to perform some sql operation the unicode text is changed to "?????" Eg, the query below

declare @unicodetext nvarchar(250)
set @unicodetext='बन्द'
select @unicodetext

results

What is the solution for this? Thanks

Answer 1

Try

declare @unicodetext nvarchar(250)
set @unicodetext = N'बन्द'
select @unicodetext

Maybe you noticed that SQL Server uses N to any quoted string input when generating DDL scripts for you.