MySql database at the moment has:
- Character Set: utf8
- Default Collation Name: utf8_unicode_ci
I want to change it to:
- utf8mb4
- utf8mb4_unicode_ci
I would also do the same thing for all tables in the database.
My question is the following:
- By doing that change is there a possibility that the content of my columns gets messed up in any way? (Cause I am really scared to do it!!!)
- I have millions of rows in the tables, is there ANY way to do a check after I make the switch that the content of all tables is the OK?
- Some crazy ideas I am thinking of include:
- Running some scripts to compare original DB to changed DB
- Running some scripts to calculate column sizes of original DB to changed DB
- Some crazy ideas I am thinking of include:
Any help or ideas which would guide me to the right direction would be appreciated.
THANK YOU