[How To] Change character set and collate for all tables (and fields)
This is the template: Running this query will produce a list of ALTER TABLE queries you can adjust (remove/modify lines for some tables etc.). Just replace [CHARACTER-SET], [COLLATE] and [DBNAME] with values you want to set. If you want to run the code right away just modify statement like this: For example below you can… Read more [How To] Change character set and collate for all tables (and fields)