[SOLVED] database builder

when i change to varchar field in a table produces error:

Syntax error near ‘COLLATE ‘utf8_general_ci’ NOT NULL AFTER Youtube, COMMENT=’’ REMOVE PARTITIONI’ at line 2 Comando SQL
ALTER TABLE book
CHANGE Allegato Allegato varchar COLLATE ‘utf8_general_ci’ NOT NULL AFTER Youtube,
COMMENT=’’
REMOVE PARTITIONING;

Not sure which database you use, but the third party Database builder does have some issues. Just copy/paste the statment into the sql window of the database builder and modify it to the correct syntax. What where you trying to do?

i solve,thanks…use mysql, you must enter the length of the field