How to convert your latin1 mysql table to utf8

Convert the existing columns content if there are unicode characters saved in non `utf8` column: UPDATE `databasename`.`prescription_template_billing_item` SET description = @txt WHERE char_length(description) = LENGTH(@txt := CONVERT(BINARY CONVERT(description USING latin1) USING utf8));