Jump to content

problem with MySQL BLOB binary/hex strings (been trying for hours)


attilio

Recommended Posts

hi everyone, i really need some help- ive been trying for hours and im working with a horrible website system which i am not 100% familiar with- the system was created by a programmer before me and i have no contact with him...

 

From what i can see the database stores the translations for a website in mySQL BLOB format which looks like some kind of hexadecimal format.

 

The problem lies when i try and work with these strings that come back from the database, they seem to be irresponsive to strtolower and all sorts of normal string commands and when i do a strlen on them they are longer than what i see when i echo them. I believe then that these strings are encoded in some way within php and then to the web browser they are decoded.

 

So ive tried to use hex to string decoders, binary to hex, hex to string decoders etc to try and get the actual string rather than, what im guessing is a hexadecimal binary encoded version.

 

Is there a way of converting these strings to standard strings or can anyone help me out with this... ive been trying for hours!!!

hi mate, thanks for your help, i tried base_64 decode but it just comes up with random characters... and md5 encryption?? theres no php encryption, unless BLOB encrypts?? either way when i export the SQL i get values like this: 0x737061696e which seems to decode using an online hexadecimal decoder but i really dont know how mysql deals with this kind of data... when does it change? or does it only change to human readable characters when the browser interprets it?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.