Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Umlauts get lost on SQL export from one server to another

veloopity's profile image veloopity posted 2 months 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 months 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 months 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 months ago Permalink

thanks Ansgar, this worked !!!

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.