On 23.02.2001 13:35:33 ?iso-8859-1?Q?Daniel_Als=E9n?= wrote: > tried changing the type to TEXT and 2000 as fieldlength. But i only get a > syntax error. What did you type and what was the error? Maybe the VARCHAR field was indexed without bounds? That's not possible for BLOB types; you have to specify a limit for the index length when you index a BLOB type. Further, you cannot specify the length of a BLOB type. --------------------------------------------------------------------- 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