View Single Post
  #3 (permalink)  
Old November 16th, 2010, 04:31 AM
rupen rupen is offline
Registered User
Points: 1,897, Level: 17
Points: 1,897, Level: 17 Points: 1,897, Level: 17 Points: 1,897, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2005
Location: Mumbai, Maharastra, India.
Posts: 352
Thanks: 14
Thanked 0 Times in 0 Posts
Send a message via Yahoo to rupen
Default

I tried with NVARCHAR, the result is it displays 18 square boxes.

The varbinary value is:
0x0C1CE86CF78D5BC413FE34215DC611327FE09D27E8868196 5CEB36C3971B791527DEC8E3

I am trying in sql query analyzer as :

SELECT convert(nvarchar(256),UserPwd)
FROM [User]
WHERE UserName = 'testuser'
Reply With Quote