"ERROR 1833 (HY000): Cannot change column" When running "ALTER TABLE <table_name> CONVERT TO CHARACTER SET" (Doc ID 2211628.1)

Last updated on DECEMBER 29, 2016

Applies to:

MySQL Server - Version 5.5 to 5.7 [Release 5.5 to 5.7]
Information in this document applies to any platform.

Symptoms

Convert a table within the database with existing data failed with the next error message:

 

These 2 options handle the data in the database. However they do not address things like client connections, the application level, setting the server character set, etc. So be sure to consider that.

For more information on MySQL and Character Sets, see the 'Globalization' section of the MySQL manual.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms