I have a database with standard US character sets and patient names. We have not until this point usefully used Unicode to store any foreign characters. Current database is from version 5.0.8 with collation
latin1_swedish_ci. Does changing directly to
utf8mb4_general_ci cause any loss of data. I have no reason to believe we have used anything but really standard US ascii chars(a-z, 1-9, and other english normative chars) in our data. If NO for changing to
utf8mb4_general_ci can we change to
utf8_general_ci? Why or why not?
My understanding is that going to a more advanced collation does not affect your data, but moving a less advanced (or notably different) collation will cause data loss, is this notion correct?