Export Data to SQL - Problem with mutated vowel like ü / ä / ö - Umlaute / Sonderzeichen

[expired user #8572]'s profile image [expired user #8572] posted 9 years ago in General Permalink
Hi everybody,

i use Heidi to export a mySql-db to a single SQL file.
In the DB are values like "Spätburgunder" etc.
When I import the sql file the value will set to "Spätburgunder". I don't know what i'm doing wrong.
In the sql file "example.sql" the vale is already "ä".

This is how I export the file:
1.) Select DB -> right click -> DB SQL Export
2.) In the new Form "Table Tools (Tabellen Werkzeuge)" (sorry I use the german version) I use SQL Export -> databases (no check) | tables (no check) | data (DELETE + INSERT) Single.sql file

Import:
I've allready have a db with all the tables. The DB collation is set to: latin1_german1_ci
1.) "Ctrl+O" to load the sql file.
2.) Select SQL File and "open".

What do i wrong? I appreciate any help, thanks!

jfalch's profile image jfalch posted 9 years ago Permalink
this is called "utf-8 encoding". a collation of latin1_xxx for the db / table imported to implies that it has character set latin1 (= windows1252). ä is what a utf-8 ä looks like when it is written into a latin1 db.

try to add the statement "SET NAMES utf8;" at the top of the generated sql file.
kalvaro's profile image kalvaro posted 9 years ago Permalink
Does something change if you choose "UTF-8" in the "Encoding" combo, rather than "Auto detect (may fail)"?

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