I have 2 tables:clientsclientname VARCHAR(50)
clientnumber VARCHAR(6)ticketsclientname VARCHAR(50)
clientnumber VARCHAR(6)tickets.clientname is a text edit tag, lookup table linked to clients.clientname with force selection enabled (type ahead). Auto fill is enabled to populate tickets.clientnumber.This works fine for any client names except those with an apostrophe, an ampersand, or even a comma. For example:Ben and Jerrys Ice Cream - GOOD
Ben and Jerry’s Ice Cream - NO GOOD (tickets.clientnumber doesn’t populate on add)
Ben and Jerrys, LLC - NO GOOD
Ben & Jerry’s, LLC - NO GOOD
I just recently changed to Maestro and it looks like it converted stuff:–
mysql> SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = “mydb”;
±---------------------------+
| default_character_set_name |
±---------------------------+
| latin1 |
±---------------------------+1 row in set (0.00 sec)This was all UTF-8 when I started.Do you have a link/advice to mass convert everything back? Straight UTF-8 or UTF-8MB4?I’m 2019 v0.10 on this project.DB is 5.5.62Can anyone else on 2019 confirm?All tables and are confirmed utf-8.