RE: [PHP-DB] TEXT lenght

This is not practical because a field of type "text" is of arbitrary length. If you want to limit the field, use varchar as you did with your other text fields. Sam Masiello System Analyst Chek.Com (716) 853-1362 x289 smasiello@chekinc.com -----Original Message----- From: Sharif Islam [mailto:mislam@students.uiuc.edu] Sent: Monday, July 17, 2000 4:32 PM To: php-db@lists.php.net Subject: [PHP-DB] TEXT lenght I am getting error for this: CREATE TABLE table_name ( id INT NOT NULL AUTO_INCREMENT, first TEXT(20), last VARCHAR(20), phone VARCHAR(20), PRIMARY KEY(id) ); Is it legitimate to assign a field length when using data type TEXT? It seems to be the problem here. Thanks in advance -Sharif -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net