[Phpmyadmin-devel] Textfields as 0x...?

Marc Delisle DelislMa at CollegeSherbrooke.qc.ca
Sun May 4 05:21:58 CEST 2003

Garvin Hicking a écrit:
> Hi Marc!
>>I checked bug 731866. The problem is that we are using
>>PMA_mysql_field_type(), which returns 'blob' when field type
>>is 'text'.
>>libraries/build_dump.lib.php3 is the only place we use
>>In fact, in phpMyAdmin we always avoided using mysql_field_type(),
>>because of this problem.
>>See in tbl_change.php3, how we set $is_blob, with "SHOW FIELDS FROM...".
>>We are using "SHOW FIELDS" in a lot of places.
>>So maybe remove PMA_mysql_field_type() and do a generic
>>PMA_get_field_type() which does not use mysql_field_type().
> Ah, thanks for investigating that. As I'm not familar with that issue and I don't
> want to seriously cause inconsitencys, who's willing to do this? I think using a
> generic get_field_type sounds got...

I had a quick look. Doing a generic function would be easy, but in this 
case, PMA_getTableContent() can have an optional $sql_query, so maybe 
it's not just a question of getting the type when we know the db name
and table name.

Still thinking about it...


More information about the Developers mailing list