Change the Character Set & Collation of a table
To change the Character Set and Collation of a field of a table you have to use this query: if the table contains data, you have to update that data as follow:
To change the Character Set and Collation of a field of a table you have to use this query: if the table contains data, you have to update that data as follow: