To change MySQL table column encoding:
ALTER TABLE artists
CHANGE [fieldname] [fieldname] [fieldtype]
CHARACTER SET [encoding]
COLLATE [collation];
To change table encoding:
ALTER TABLE [tablename]
CONVERT TO CHARACTER SET [encoding]
COLLATE [collation];
To change database encoding:
ALTER DATABASE [dbname]
CHARACTER SET [encoding]
COLLATE [collation];