MYSQL Blobs?!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Rob_Beard
Forum Newbie
Posts: 23
Joined: Sat Oct 12, 2002 11:58 am

MYSQL Blobs?!

Post 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
hurkle
Forum Newbie
Posts: 15
Joined: Tue Feb 11, 2003 1:21 pm
Location: Minnesota, USA

Post by hurkle »

try using a TEXT type column, that should handle anything you want to throw at it, just about.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Post Reply