attilio Posted May 26, 2009 Share Posted May 26, 2009 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!!! Link to comment https://forums.phpfreaks.com/topic/159763-problem-with-mysql-blob-binaryhex-strings-been-trying-for-hours/ Share on other sites More sharing options...
redarrow Posted May 26, 2009 Share Posted May 26, 2009 have you tried the base64_decode($value); yet? LINK http://uk2.php.net/base64_encode if it dose not work then i suspect a md5 encryption. (guessing. please post a encrypted valid code Link to comment https://forums.phpfreaks.com/topic/159763-problem-with-mysql-blob-binaryhex-strings-been-trying-for-hours/#findComment-842635 Share on other sites More sharing options...
attilio Posted May 26, 2009 Author Share Posted May 26, 2009 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? Link to comment https://forums.phpfreaks.com/topic/159763-problem-with-mysql-blob-binaryhex-strings-been-trying-for-hours/#findComment-842701 Share on other sites More sharing options...
redarrow Posted May 26, 2009 Share Posted May 26, 2009 i dont get you then how is the code encoding the info , we need top see how it encoded or set up. can you post the code that encodes the code to the database please. Link to comment https://forums.phpfreaks.com/topic/159763-problem-with-mysql-blob-binaryhex-strings-been-trying-for-hours/#findComment-842723 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.