Welcome to WebmasterWorld Guest from 54.159.189.139

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)

Junior Member

5+ Year Member

joined:July 8, 2007
posts:147
votes: 0


Hi,

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 Sept 26, 2010 (gmt 0)

Preferred Member

10+ Year Member

joined:Dec 7, 2001
posts: 579
votes: 0


I'm no expert, but it seems to me that your problem lies in the area of "charset"
Example:
<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 Sept 28, 2010 (gmt 0)

Junior Member

5+ Year Member

joined:July 8, 2007
posts:147
votes: 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.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members