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!
Export Data to SQL - Problem with mutated vowel like ü / ä / ö - Umlaute / Sonderzeichen
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.
try to add the statement "SET NAMES utf8;" at the top of the generated sql file.
Please login to leave a reply, or register at first.