The Ultimate Guide to High Availability with MariaDB

Comments - ALTER TABLE

8 years, 8 months ago Paul Weiss
Using MODIFY for character sets & collations

The documentation page for Setting Character Sets and Collations, gives the examples:

ALTER TABLE table_name MODIFY ascii_text_column TEXT CHARACTER SET utf8;
ALTER TABLE table_name MODIFY ascii_varchar_column VARCHAR(M) CHARACTER SET utf8;

However, this page does not include CHARACTER SET or COLLATION in the column_definition specification. Should that be changed?

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.