title: SQL hashing a password
body: <p>I am manually importing from old data to MSSQL using SQL statement.
  when i am hashing from raw text password to MVC 5 passwordHASH field in database.I get funny characters. How do i insert hash to mvc5 identity table?MVC 5 table is use nvarchar also</p>
  
  <pre><code>select HASHBYTES('SHA2_512', 'P@ssw0rd')as beforehash --looks good in result
  0x6BFCC4026B5F162799A6DC8305C09DB9C1674AC616BD5C7422A45FBB6D0816AC163047C47A1F426F4F4C6B5B5042C671EABC4FDC7310FD5B183EEF59DC274604
  
  declare @afterhash nvarchar(128)
  set @afterhash=HASHBYTES('SHA2_512', 'P@ssw0rd')
  select @afterhash as afterhash --funny character if put inside a variable or insert to data base
  
  ﱫ˄彫✖ꚙ菜쀅릝柁왊봖瑜ꐢ뭟࡭갖〖쑇ὺ潂䱏孫䉐燆볪�ၳ寽㸘姯⟜ц
  </code></pre>