| Welcome to WebmasterWorld Guest from 184.108.40.206 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|how to turn BLOB back to be readable text?|
| 8:36 am on Sep 26, 2010 (gmt 0)|
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)|
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)|
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.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved