I have an old problem that was discussed several times at the forum.
In any case I can not find appropriate solution that works for me.
I have a database at MySQL Server.
Code: Select all
SHOW VARIABLES LIKE 'ver%'
"Variable_name" "Value"
"version" "5.5.34"
"version_comment" "MySQL Community Server (GPL)"
"version_compile_machine" "x86"
"version_compile_os" "Win64"
Code: Select all
SHOW VARIABLES LIKE 'char%'
"Variable_name" "Value"
"character_set_client" "utf8"
"character_set_connection" "utf8"
"character_set_database" "utf8"
"character_set_filesystem" "binary"
"character_set_results" "utf8"
"character_set_server" "utf8"
"character_set_system" "utf8"
Code: Select all
Database charset: utf8
Database collation: utf8_general_ci
Here I have some strange points (do not ask me why it is so... My customer owns the database).
Code: Select all
Tablename: kunden
Charset = latin1
Collation = latin1_swedish_ci
Then in my win32 application in Delphi XE7 I have TUniConnection.
Code: Select all
SpecificOptions['UseUnicode'] = True
SpecificOptions['Charset'] = utf8
Code: Select all
SpecificOptions['Charset'] = auto
Code: Select all
FDump.BackupToFile(filename);
As next step I need to restore new database from this backup.
I create a database with the same settings on the same server and execute:
Code: Select all
FDump.RestoreFromFile(filename);
Database is restored without any error exceptions but on places of umplauts I have question marks "?".
It is absolutely clear for me that I have a problem in my settings.
But please show me my mistake.
Thanks a lot for advance.