BLOB field limit

[TraScoPur]

Got a weird thing going on here, and can't find a solution to it anywhere.

I have a DB that has a TEXT field with data in it that is >255 chars in length. In PHP, when I try to access that information (using mysql_fetch_assoc), the data retreived is capped at 255 chars. In PHPmyadmin and Navicat I can see that all 255+ chars of the TEXT data is correctly stored, but when I do a mysql_fetch_field on that field, it tells me that the max_length is 255, type BLOB (even though it's a TEXT field).

Any thoughts?

Thanks

[bastien]

what is the query? is it something with the query?

have you tried mysql_fetch_array?