Python bytes to string for SQL Server rowversion data type

Question

I'm reading a rowversion data type from SQL Server using Python and getting back a bytes representation like b'\x00\x00\x00\x00\x00\x00\x18\x9c'.

How can I decode this?

I've tried a few codecs but it's not returning the expected result. Decoded value should be 0x000000000000189c. I'm not seeing much on this data type and what the encoding is so I'm kinda lost.

Edit: I didn't need to decode, I needed to convert from bytes to hex (doh)

There is nothing to decode, it's just a bunch of bytes that identify the LSN when the row was last updated. Perhaps you just want to convert the bytes to a hex string representation stackoverflow.com/questions/19210414/byte-array-to-hex-string — Charlieface
– Charlieface, Commented Oct 4, 2021 at 22:33
Ah I see, I just need to convert to hex. How do I get the first 0x or is that always the first two characters? — nobody
– nobody, Commented Oct 4, 2021 at 23:20

nobody · Accepted Answer · 2021-10-04 23:53:13Z

0

I was mistaken, I don't need to decode. Calling hex() on the bytes gets a close representation as to what it is in SQL Server

b'\x00\x00\x00\x00\x00\x00\x18\x9c'.hex()
'000000000000189c'

answered Oct 4, 2021 at 23:53

nobody

3104 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python bytes to string for SQL Server rowversion data type

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related