#3578 (ok 4.0.5) Transformations for text/plain on a BLOB column

[Jean-Ro]

When I have a field with Type BLOB, I add MIME type = text/plain and Transformation = "text/plain: substr",
but when I browse the table, it shows "[BLOB - nnnB]" in place of the text value.

I tested this with several versions including the latest one (2012-04-23).

I think it should modify the file libraries/display_tbl.lib.php, replacing the line (about #2746 in the latest relase)
if (strpos($transform_function, 'octetstream')) {
by
if (strpos($transform_function, 'octetstream') || strpos($transform_function, '_text_')) {

Thanks

[Marc Delisle]

phpMyAdmin assumes that when you are using a BLOB type for a column, you do not intend to put text in it.

[Jean-Ro]

I do this for performance reasons,
to avoid treatments related to the charset and case comparisons.

My database has to handle 300 requests per second on average over a year.

I do not understand the use of transformations text/plain in this case.

[Marc Delisle]

Fix for 4.0.5:
https://github.com/phpmyadmin/phpmyadmin/commit/3fde4efd51f3c92ff0369f1047c1b5b858d334e1