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;