Page 1 of 1

Need more then 255char. in database table

Posted: Sat Jul 31, 2004 3:55 am
by Lucnet
I have created a table with this layout:

CREATE TABLE ls_testimonials (
id bigint(20) unsigned NOT NULL auto_increment,
client_id varchar(255) default NULL,
link_display varchar(255) default NULL,
company varchar(255) default NULL,
email varchar(255) default NULL,
testimonials varchar(255) default NULL,
approved enum('y','n','h') NOT NULL default 'n',
PRIMARY KEY (id)
) TYPE=MyISAM;

I am needing more then 255 charectors in the testimonials line. What is another function I can call on. When I try to change to a bigger number MySQL tells me it can't be done to use BLOB.

I am very new with MySQL and php. All help is appreciated.

Posted: Sat Jul 31, 2004 3:59 am
by feyd
TEXT is the next size up text field.. 64K of text can be held: http://dev.mysql.com/doc/mysql/en/BLOB.html

Posted: Sat Jul 31, 2004 8:29 am
by markl999
There's also :
TINYBLOB, TINYTEXT
MEDIUMBLOB, MEDIUMTEXT
LONGBLOB, LONGTEXT

http://dev.mysql.com/doc/mysql/en/Stora ... ments.html

Posted: Sat Jul 31, 2004 2:23 pm
by Lucnet
Thanks