hi
You can not store unicode data in non unicode column. So you will have to store unicode data as nvarchar
DECLARE @Hindi varchar(64)
SET @Hindi = 'धन्यवाद'
DECLARE @nHindi nvarchar(84)
SET @nHindi = N'धन्यवाद'
SELECT @Hindi, @nHindi
In the above example when 'धन्यवाद' (Thank you in Hindi) stored as varchar it displays as ????? in the query editor.
or i think it may definetly helps you....
thanks
[From 2nd solution - same author]
hi
i think it may helps you....
Unicode Data Type in SQL[
^]
thanks