title: Storing binary data as nvarchar/varchar data in sql server
body: <p>Is it possible to store <code>binary</code> data as <code>varchar</code>/<code>nvarchar</code> in SQL servers tables?</p>
  <p>Example I am trying to store binary data  <code>0x6806000004000000</code> as <code>nvarchar</code> data type but while trying to save to the tables values are getting blanked out. I want them to be stored as strings</p>
  <p>Code used</p>
  <pre><code>declare @tempBinayToVarchar table (FinalValue NVARCHAR(60))
  Insert into @tempBinayToVarchar
  select Value from basetable 
  </code></pre>
  <p>Values in the table are values like:</p>
  <pre><code>0x000000000000000000000000000000000000000000000000000000000000004
  </code></pre>