I have a server running UwAmp and I was using phpMyAdmin to run a database. When I was looking through it, I noticed it was using utf_16_swedish_ci. It was working perfectly fine, however I wanted to change it to utf_16_general_ci like we had been told to for this project. when I did, this happened to my data:
I changed it back to Swedish, but the data is the same. Is there any way to fix this other than individually editing each entry?