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.
[SOLVED] Need more then 255char. in database table
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
TEXT is the next size up text field.. 64K of text can be held: http://dev.mysql.com/doc/mysql/en/BLOB.html
There's also :
TINYBLOB, TINYTEXT
MEDIUMBLOB, MEDIUMTEXT
LONGBLOB, LONGTEXT
http://dev.mysql.com/doc/mysql/en/Stora ... ments.html
TINYBLOB, TINYTEXT
MEDIUMBLOB, MEDIUMTEXT
LONGBLOB, LONGTEXT
http://dev.mysql.com/doc/mysql/en/Stora ... ments.html