Hash Conversion from Postgres to Rails

Question

I am not sure what type of coded hash I am getting back from a postgres database that when queried shows instead a different code.

The question is...

how to convert this hash (as it is returned from Rails):

\x158\x06\xDB\xCD\x13M\xDE\xE6\x9A\x8CR\x04\xE3\x8A\xC8\x04H\xF6#B\xF8\xC2<\xFEK~\xDF

into this (as it shows inside the postgres database):

\x153806dbcd134ddee69a8c5204e38ac80448f62342f8c23cfe4b7edf

Pierre D · Accepted Answer · 2021-01-03 16:51:38Z

1

The first hash (as you say, coming from Rails) is a byte array, in which any printable character is left as is instead of being converted to hex: \x158 is really two characters: '\x15' and '\x38' ('8').

In the Postgres table, that byte array is the same, but the format is to hexlify the whole thing.

So:

\x158\x06\xDB\xCD\x13M... is really \x15,8,\x06,\xDB,\xCD,\x13,M
-- becomes
\x153806dbcd134d... ('8':\x38, 'M':\x4d)

answered Jan 3, 2021 at 16:51

Pierre D

26.6k8 gold badges71 silver badges108 bronze badges

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

3 Comments

user3755529 Over a year ago

is there a way to hexify a byte array in Rails?

Pierre D Over a year ago

possibly, by adapting this.

user3755529 Over a year ago

for future reference this helped me

Collectives™ on Stack Overflow

Hash Conversion from Postgres to Rails

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related