Why can't binary data be inserted/displayed as ones and zeroes?
1
vote
1
answer
816
views
If I have a column of type
binary
or varbinary
, I imagine the data as a sequence of bits. For example, it makes sense to me that 01001
(as a base 2 number) could be a valid value in a binary(5)
column.
Is there a reason why inserting and displaying binary data in this fashion is not straightforward?
For example, why does SSMS convert binary data to hexadecimal instead of displaying a sequence of ones and zeroes (which in my opinion is much easier to reason about)?
Asked by Jacob Stamm
(121 rep)
Dec 2, 2021, 06:31 PM
Last activity: Dec 10, 2021, 09:52 AM
Last activity: Dec 10, 2021, 09:52 AM