what else can I use instead of varchar

[Anon]

I set my database using the following variables and code:

<?
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE test(id int(6) NOT NULL auto_increment,description varchar (255) NOT NULL,picture_small varchar(40) NOT NULL, picture_large varchar(40) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
mysql_query($query);
mysql_close();
echo "Database created";
?>

I want to be able to enter more than 255 characters into the database. At the moment im using varchar(255) for this input. What statment do I use instead of varchar to allow more than 255 characters to be entered.

[Anon]

'text'

🙂

[[deleted]]

There's a list of all available datatypes and what they can store, all you have to do is read the mysql manual on the mysql website.