开发者

mysql automatically sets UNHEX for LONGBLOB in database

开发者 https://www.devze.com 2023-03-13 05:24 出处：网络

Hi I am storing some images in MySQL DB in a LONGBLOB field. Whenever this image is stored MySQL sets the function for this column to UNHEX. I dont want this to be automatically set to that. My BLOBs

相关专题：blob php

Hi I am storing some images in MySQL DB in a LONGBLOB field. Whenever this image is stored MySQL sets the function for this column to UNHEX. I dont want this to be automatically set to that. My BLOBs used to work fine when this was not set. How do I remove this UNHEX being set by default.

I am using phpmyadmin, MySQL, InnoDB and PHP to retrieve those images. I used to get back the images perfectly fine b开发者_StackOverflow中文版efore we migrated to a new version of phpmyadmin.

Please help.

If you check the phpmyadmin changelog (http://demo.phpmyadmin.net/master-config/changelog.php), it does appear there are a few issues noted regarding this problem with earlier versions of PMA (see the note under 3.4.0.0 about defaulting to UNHEX). You might want to upgrade to the latest version and see if these problems still exist.