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?

Regards

Edit:

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 utf-8-Strings