I've got a database that's uft8_general_ci, only issue is up to this time a credit card applicatoin coded with a previous developer appears to possess been dealing with the database in latin-1.
I've since transformed the way the application uses the database and may now store an umlaut being an umlaut rather than Ã¼. The issue now would be that the application reads the formerly existing data in the database as (example) 'SÃ¼ddeutsche' rather than 'Süddeutsche'.
Can there be anyway to transform the information within the database in one format towards the other?
ALTER TABLE TableName MODIFY ColumnName ColumnType CHARACTER SET latin1; ALTER TABLE TableName MODIFY ColumnName ColumnType CHARACTER SET binary; ALTER TABLE TableName MODIFY ColumnName ColumnType CHARACTER SET utf8;
This labored for me personally.
You could attempt
SET NAMES to allow the Database talk in
latin-1 together with your application while storing in
utf-8 or you will have to convert all previous Datasets to