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

[Chanaka Dharmarathna]

Hi,


> 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>