Thread: How do i increase the characters limit on an imput field (Not BV)

Hi, I am trying to increase a field size from 255 characters to 450 for text.
Its part of a description for an image. Am I doing this in the right place?????

Thanks.


CREATE TABLE IF NOT EXISTS `gallarific_comments` (
`commentid` int(11) NOT NULL auto_increment,
`photoid` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`email` varchar(250) NOT NULL default '',
`comment` text NOT NULL,
`dateadded` int(11) NOT NULL default '0',
`status` tinyint(4) NOT NULL default '0',
`link` varchar(255) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
PRIMARY KEY (`commentid`)
);

CREATE TABLE IF NOT EXISTS `gallarific_galleries` (
`galleryid` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`description` varchar(455) NOT NULL default '',
`created` int(11) NOT NULL default '0',
`parentid` int(11) NOT NULL default '0',
`sort` int(11) NOT NULL default '0',
PRIMARY KEY (`galleryid`)
);

CREATE TABLE IF NOT EXISTS `gallarific_photos` (
`photoid` int(11) NOT NULL auto_increment,
`galleryid` int(11) NOT NULL default '0',
`filename` varchar(100) NOT NULL default '',
`description` varchar(455) NOT NULL default '',
`size` int(11) NOT NULL default '0',
`dateuploaded` int(11) NOT NULL default '0',
`views` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`status` tinyint(4) NOT NULL default '0',
`tags` varchar(255) NOT NULL default '',
`votetotal` int(11) NOT NULL,
`votecount` int(11) NOT NULL,
PRIMARY KEY (`photoid`)
);

CREATE TABLE IF NOT EXISTS `gallarific_stats` (
`ID` int(11) NOT NULL auto_increment,
`Var01` varchar(255) NOT NULL default '0',
`Var02` varchar(255) NOT NULL default '0',
`Var03` varchar(255) NOT NULL default '',
`Var04` varchar(255) NOT NULL default '',
`Var05` varchar(255) NOT NULL default '',



`Var06` varchar(255) NOT NULL default '',
`Var07` varchar(255) NOT NULL default '',
`Var08` varchar(255) NOT NULL default '',
`Var09` varchar(255) NOT NULL default '',
`Var10` varchar(255) NOT NULL default '',
`Var11` varchar(255) NOT NULL default '',
`Var12` varchar(255) NOT NULL default '',
`Var13` varchar(255) NOT NULL default '',
`Var14` varchar(255) NOT NULL default '',
`Var15` varchar(255) NOT NULL default '',
`Var16` varchar(255) NOT NULL default '',
`Var17` varchar(255) NOT NULL default '',
`Var18` varchar(255) NOT NULL default '',
`Var19` varchar(255) NOT NULL default '',
`Var20` varchar(255) NOT NULL default '',
`Var21` varchar(255) NOT NULL default '',
`Var22` varchar(255) NOT NULL default '',
`Var23` varchar(255) NOT NULL default '',
PRIMARY KEY (`ID`)
) AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `gallarific_users` (
`userid` int(11) NOT NULL auto_increment,
`username` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`usertype` enum('superuser','normaluser') NOT NULL default 'superuser',
`firstname` varchar(100) NOT NULL default '',
`lastname` varchar(100) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`datejoined` int(11) NOT NULL default '0',
`website` varchar(255) NOT NULL default '',
`issuperuser` tinyint(4) NOT NULL default '0',
`photo` varchar(100) NOT NULL default '',
`joincode` varchar(20) NOT NULL default '',
PRIMARY KEY (`userid`)
);

Chris, creating a VARCHAR column of 455 chrs will result automatically in creating a text type column, so don't worry. Or did i misunderstood ?

However i don't see how you require it to be NOT NULL and in the same time have as default no content

Hi George,
On this page there is some text above the image. (Testing to see how it looks) in the admin area there are fields to fill in & one of them is “Description” but seems to be limited to around 255 characters, & was trying to increase to about 450’ish.
This was the only part of the script I could even see a reference to the 255 number & thought this might be something to do with it. (Have never got my head around mysql) so it might not have a thing to do with it. lol.

Cheers.

Hi Chris,

this is the table creation part. This means that changing it, you will actually create a column for 455 characters, however it is not certain that this is the only part where the length is being controlled, the length usually is controlled by the script that processes the user dubmission.

I shall investigate. LOL Might need your services for a database, but will contact you via the site when i have shorted the needs fully.

Cheers.

The max for a varchar is 255 character, so just make it a text or blob which will easily hold 450 characters