When I use 'propose table structure', the fields field name and optimal field type are shown as hex instead of as text. This is related to the recent change to display binary fields as hex. How does pMA determine what is a binary field?
This is a very tricky area. MySQL reports these fields as being binary. I discussed this in the past with a MySQL engineer but there was no evident solution.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Olaf,
After seeing bug 2974067 I think we don't have a choice and will have to set the default to not display binary as hex. Please comment in bug tracker 2974067.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is a very tricky area. MySQL reports these fields as being binary. I discussed this in the past with a MySQL engineer but there was no evident solution.
Do you have a link to that discussion?
One work around might be to check the string is ascii/utf-8 and display it as text in that case.
Sorry, I think I must have submitted to bugs.mysql.com, I'll try to find it.
Looking at the code, I might have found a solution, stay tuned.
This bug was fixed in repository and will be part of a future release; thanks for reporting.
Just curious, how did you fix it?
Please have a look at http://phpmyadmin.git.sourceforge.net/git/gitweb.cgi?p=phpmyadmin/phpmyadmin;a=commitdiff;h=7a366c3f088cc060b769d56378605c6473b185e8 and you can get the patch from there.
Also I suggest you use "git" to be able to try fresh fixes. See http://wiki.phpmyadmin.net/pma/Devel:Git
Olaf,
After seeing bug 2974067 I think we don't have a choice and will have to set the default to not display binary as hex. Please comment in bug tracker 2974067.