Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

how to turn BLOB back to be readable text?



8:36 am on Sep 26, 2010 (gmt 0)

5+ Year Member


I have a mysql table with columns "author_name" (such as Apple) and "text".

In localhost, the text displays very well in phpMyAdmin, however when I uploaded everything to my host, the value in the columns suddenly become "[BLOB]".

Everything still works fine, but i can't access those data directly from my phpMyAdmin anymore.

do you know how to turn [BLOB] back to a readable text?

thanks for your help.


10:54 am on Sep 26, 2010 (gmt 0)

10+ Year Member

I'm no expert, but it seems to me that your problem lies in the area of "charset"
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

If the rendered web page is not on the same wavelength as the Db Table, what you describe is quite possible.


12:11 pm on Sep 28, 2010 (gmt 0)

5+ Year Member

thanks! it's exactly what happened.

I've changed the Collation setting in PhpMyAdmin and adjust the encoding. It's displayed without any problems now.

Featured Threads

Hot Threads This Week

Hot Threads This Month