Backup with wrong special characters
Posted: Thu 04 May 2017 06:22
UniDAC version: 4.6.12
Database: MariaDB (version 10.1.13)
Hello,
i have a Maria DB with collation utf8_general_ci.
One database table is a language table with german special characters like 'äöü' and also chinese characters.
I tried to create a database backup with your TUniDump component. My code looks like this (excerpt):
The code is working. I get a backup file. But the data within the file is not correct.
I get e.g.:
(1001, 'Löschen', 'Delete', 'åˆÂ*除'),
instead of as desired:
(1001, 'Löschen', 'Delete', '删除'),
Where is my mistake ? What must i do ?
Database: MariaDB (version 10.1.13)
Hello,
i have a Maria DB with collation utf8_general_ci.
One database table is a language table with german special characters like 'äöü' and also chinese characters.
I tried to create a database backup with your TUniDump component. My code looks like this (excerpt):
Code: Select all
var
FBackupFilename: String;
FConnection: TUniConnection;
FUniDump: TUniDump;
...
FConnection := TUniConnection.Create(nil);
FConnection.Assign(aDBConnection);
FConnection.SpecificOptions.Values['Charset'] := 'utf8';
FConnection.SpecificOptions.Values['UseUnicode'] := 'true';
FConnection.Connect;
...
FUniDump := TUniDump.Create(nil);
FUniDump.Connection := FConnection;
FUniDump.TableNames := ''; // all tables
FUniDump.BackupToFile(FBackupFilename);
I get e.g.:
(1001, 'Löschen', 'Delete', 'åˆÂ*除'),
instead of as desired:
(1001, 'Löschen', 'Delete', '删除'),
Where is my mistake ? What must i do ?