sql server - How Binary Data is represented in SQL database -


I have a field named x where the field type is binary (15). Now I am updating the table

  update table_name set x = 567845329090989 where some_condition   

I now see after executing the above command in the table The column is updated with the following

  0x0000000F000001ADB920CB73040200   

This is not hexadecimal value how is it working?

  • 567845329090989 bigint decimals (15, 0)
  • Using the Windows calculator, it is 0x20473 CB 20b 9 AD
  • The value above is 0x0000000F000001 ADB920CB730402 00

    I forget the correct details but it is for

Comments