How to modify the collation of a column?
I am trying to modify the collation of a column to be latin1_general_ci
Here is what I have:
ALTER TABLE page MODIFY COLUMN page_title <column type> latin1_general_ci
It doesn't work. please help.
Answer Answered by Joseph Hobbs in this comment.
Found solution: ALTER TABLE page MODIFY COLUMN page_title varchar(25) COLLATE latin1_general_ci
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.
