Page 1 of 1

MYSQL Blobs?!

Posted: Wed Feb 26, 2003 10:32 am
by Rob_Beard
Hey all,

I'm trying to build a completely database dependant site, and i want a column in a mysql table to support more than 500 characters for HTML content, which is all i can seem to get from other types. I tried using Blob, but i can't seem to input data to it?

Could someone please give me a short guide of how to set it up?

I've tried setting it up as you would any other column, it shows up in phpmyadmin, but i get errors when i try to add data.


cheers

Rob

Posted: Wed Feb 26, 2003 10:46 am
by hurkle
try using a TEXT type column, that should handle anything you want to throw at it, just about.

Posted: Thu Feb 27, 2003 3:32 am
by twigletmac
There's config options in phpMyAdmin to allow you to edit BLOBs but since a TEXT is just a case-insensitive BLOB, there's not much of a difference between them and phpMyAdmin allows you to edit TEXT fields:
http://www.mysql.com/doc/en/BLOB.html

Mac