SQL: SELECT binary value

Question

I have:

$token  = sha1(uniqid(mt_rand(), true));

Then I'll insert it into the database using unhex('$token'). How do I select this value?

I've tried:

SELECT token FROM `name` WHERE `id` = 1 LIMIT 1

If I echo it in it'll show as 0b7GÞ÷:‹xcÅ•½JAjdäáæ rather than something like 5dc012f007b7c4db7b9e076138fdd92fa1039530

What am I doing wrong?

"What am I doing wrong?" - how about: you are using UNHEX in the first place? I mean, what for do you do that? And if you really think this is necessary - why haven't you read in the manual about what the "inverse" function to UNHEX is? — C3roe
– C3roe, Commented Mar 17, 2013 at 0:36

Explosion Pills · Accepted Answer · 2013-03-17 00:35:44Z

1

I don't think you need to store it with UNHEX, but you can SELECT HEX(token) to get back the original value.

answered Mar 17, 2013 at 0:35

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

1 Comment

I figured out moments ago I had to do "HEX(token) as token", leaving out the as token was causing an undefined index error. Thanks. :)