Need more then 255char. in database table
Posted: Sat Jul 31, 2004 3:55 am
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.
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.