[Phpmyadmin-devel] Allow specifying mime types and transformations in queries

Chanaka Dharmarathna pe.chanaka.ck at gmail.com
Thu Aug 2 20:51:53 CEST 2012


> I'm trying to implement titled feature. [0]
> In current PMA, mime type transformations sometimes not working properly
> if the query is selecting only field with transformation.
> Sometime means, if the row data string is more lengthy, data is not
> transformed as expected. (data with string length > 1000)
> Due to that, where clause for linking a image (as example) is not setting.
> (comparison data is too heavy)
> If I use manually where clause, this will display properly.
> So as I think this can fix for only tables with primary key/unique key
> other than the field with transform.

I found a way to do this even for tables without primary/unique key by
assuming length of the data will not be equal for the blob fields.

> So that there may be a possibility to create where clause by executing sql
> (which related to display only field with transformation) with modification
> for retrieve both primary/unique key field and the relevant field and
> display only the relevant field with setting where clause properly.
> Any thoughts on this ?
> [0] :
> http://sourceforge.net/tracker/index.php?func=detail&aid=3112137&group_id=23067&atid=377411
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20120803/8ba5de8c/attachment.html>

More information about the Developers mailing list