Re: syntax error generated when using TEXT and BLOB datatypes

[Paul DuBois]

At 5:38 AM -0500 1999-12-12, root wrote:
>  >Description:
>	Cannot use datatype TEXT or BLOB when creating or altering a 
>table, keep getting syntax error near '(500))' 
>>How-To-Repeat:
>	alter table products (
>vitamins TEXT(500)
>);


BLOB and TEXT types don't take a length in MySQL.  See the manual for
information on the type names and how to use them to select the (approximate)
length you want.

-- 
Paul DuBois, paul@stripped