blob to info hash

having a mind freeze at the moment, any remember how to convert a blob field in the db to the info hash format. this has to be done just in phpmyadmin not via php.

Hello,

I don't know if the answer am going to give you is what you're looking for, but it converts a blob field to varchar

you run this sql command : ALTER TABLE `Table_name` CHANGE `blob_field_name_old` `blob_field_name_new` BLOB NOT NULL;
blob_field_name_new can be equal to blob_field_name_old.

Now if you have store the 20-byte infohash in a blob field and you want to convert it back to hex (40-bytes) and store it as varchar I don't know if there is any way to do that with mysql.
But it surely can be done with php, but you don't want to use php as you mentioned.

it was actually down to a issue of my data saving function, i was using HEX() function on the blob field which is the right way to do it but when i was inserting it was getting corrupting making the hash very different to what i was expecting making me think it was wrong. Manage to fixed the issue and HEX() worked fine.