Timeline for Converting from latin1 to utf8mb4 of ENUM and SET with accented characters on mysql
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 19, 2023 at 16:32 | comment | added | Toto | @Luuk Thanks!!! Actually it is an other table to replicate issue: "Bleu foncé", "Bleu foncé moyen". Seems like meta data is stored in ISO and does not properly convert. Maybe there is a configuration issue I have to investigate. | |
| Mar 18, 2023 at 12:14 | comment | added | Luuk |
This answer should work (see: DBFIDDLE). Please specify the COMPLETE definition from your ENUM, because 'Cor?e' does not seem to exist in the given example....
|
|
| Mar 17, 2023 at 17:45 | comment | added | Toto | Unfortunately I get the same error doing the conversion on the table or column level. May it be an old bug? heidisql.com/forum.php?t=21524 | |
| Mar 13, 2023 at 17:45 | history | answered | RolandoMySQLDBA | CC BY-SA 4.0 |