* Matthew Darcy > I am stuck on why this is not working though > > ALTER TABLE account_details ADD account_name TEXT(30) NOT NULL
TEXT is a special field type for larger text elements, up to 65535 bytes. You can not set a max length on this field type. Use VARCHAR, or drop the size restriction. VARCHAR use 1 less byte for each field, compared to TEXT, and trailing spaces are automatically removed. <URL: http://www.mysql.com/doc/C/o/Column_types.html > -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
