homepage Welcome to WebmasterWorld Guest from 54.145.182.50
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
how to turn BLOB back to be readable text?
zozzen

5+ Year Member



 
Msg#: 4207049 posted 8:36 am on Sep 26, 2010 (gmt 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.

 

piskie

10+ Year Member



 
Msg#: 4207049 posted 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"
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.

zozzen

5+ Year Member



 
Msg#: 4207049 posted 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved