0
I have a database with data inside. I need to change the colletion of a certain data from a bank table. How can I do that?
The reason is that I’m not able to register accounts with accentuation.
This is the error that appears on the console when I try to save a data accented.
I’m not the best person to answer, but I’m afraid there’s no solution. You can change the collation and the new data will come with accents, however, the old ones will probably remain "bugged" and you would have to update all the old data to fit them.
– Clayderson Ferreira
If you export the database data, recreate it with the collation correct and import them again does not work?
– Woss
It is that I created the whole structure in Workbench, I made the link between the tables and I cannot make the changes in phpMyAdmin, it does not allow.
– GustavoSevero