Charset problem using TUniDump
Posted: Mon 06 Feb 2017 12:01
Hello collegues,
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.
Inside of the database I have some tables...
Here I have some strange points (do not ask me why it is so... My customer owns the database).
Then in my win32 application in Delphi XE7 I have TUniConnection.
I tryed also:
Then I have TUniDumpComponent and execute:
What I have is nice and correct UTF8 file with all umlauts and other correct chars.
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:
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.
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'] = autoCode: 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.