homepage Welcome to WebmasterWorld Guest from 54.161.191.154
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

    
Field in mysql table showing as both a text field, and a blob
how can this be?
nippi

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 4408685 posted 8:30 pm on Jan 19, 2012 (gmt 0)

In this mysql database is a table called widgets.
When I view the widgets table, I see a field for "colour". Its marked as a text field.
When I then click on "browse" and view records in the table... the text field "colour" is shown as a blob field.
When i click on "edit" it then shows as a text field.
Command line, shows it as a text field.

what the?

Anyone else ever seen something like this?

 

penders

WebmasterWorld Senior Member penders us a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



 
Msg#: 4408685 posted 11:04 pm on Jan 19, 2012 (gmt 0)

What are you using to view/edit your database?

nippi

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 4408685 posted 11:15 pm on Jan 19, 2012 (gmt 0)

phpmyadmin

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