Umlauts get lost on SQL export from one server to another

veloopity's profile image veloopity posted 2 years ago in General Permalink

I'm exporting a database to SQL, and import it on another server. There are many German texts in it containing Umlauts. The source database and the resulting database both display their character set as 'latin1' but the Umlauts in the target database come out garbled ("ü" becomes "ü"). What can I do?

ansgar's profile image ansgar posted 2 years ago Permalink

I assume you ignored the warning about the charset auto-detection when opening the .sql file for importing?

It's important to give HeidiSQL the correct encoding when you load an sql file:

Description

ansgar's profile image ansgar posted 2 years ago Permalink

Please note the export is always UTF-8 encoded. You should probably check the file encoding with Notepad or Notepad++.

veloopity's profile image veloopity posted 2 years ago Permalink

thanks Ansgar, this worked !!!

Please login to leave a reply, or register at first.