Tweet
I am saving thumbnails in BLOBs in my mySQL database. In my Live site, the images display fine when I use a PHP source file attached to an HTML img tag to display them.
The problem is that when I export the table with the blobs and import them into a new database, they do not show up. I do not know if this is an encoding problem or some setting in the new mySQL database, but when I attempt to display the exact same image from the original database using the same image display source file, it does not work from the new code. It seems that 6 extra bytes are appended to the beginning of the image source: EF BB BF. This is causing the image to crap out and not get displayed.
Is this a result of the export and import? Am I missing something in the encoding? Everything looks the same, even the SQL export of the same table from both databases.
To be complete, these are MEDIUMBLOB’s and stored as Binary in UTF8 encoding.
Ben Cahan
Talentville.com
The problem is that when I export the table with the blobs and import them into a new database, they do not show up. I do not know if this is an encoding problem or some setting in the new mySQL database, but when I attempt to display the exact same image from the original database using the same image display source file, it does not work from the new code. It seems that 6 extra bytes are appended to the beginning of the image source: EF BB BF. This is causing the image to crap out and not get displayed.
Is this a result of the export and import? Am I missing something in the encoding? Everything looks the same, even the SQL export of the same table from both databases.
To be complete, these are MEDIUMBLOB’s and stored as Binary in UTF8 encoding.
Ben Cahan
Talentville.com