2020-04-01

mysql change column encoding

You can use this syntax (to change encoding a TEXT column to utf8):
ALTER TABLE name-of-the-table MODIFY name-of-the-column TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci

No comments:

Post a Comment

Blog Archive