Backup with wrong special characters

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mmmmuuuaaaaahhhaaa
Posts: 3
Joined: Wed 03 May 2017 13:30

Backup with wrong special characters

Post by mmmmuuuaaaaahhhaaa » 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):

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);
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 ?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Backup with wrong special characters

Post by ViktorV » Thu 04 May 2017 10:50

Unfortunately, we could not reproduce the problem on the latest UniDAC 7.0.1 version.
Please check whether the problem occurs on the latest version of UniDAC 7.0.1.
If it is reproduced, please compose a small demonstrating the described behavior and send it to us using the contact form https://www.devart.com/company/contactform.html, including scripts for creating database objects.

mmmmuuuaaaaahhhaaa
Posts: 3
Joined: Wed 03 May 2017 13:30

Re: Backup with wrong special characters

Post by mmmmuuuaaaaahhhaaa » Thu 04 May 2017 11:37

Hello,
if i install the latest version UniDAC 7.0.1 (Trial) what is with my registered version 4.6.12
Could i simply uninstall version 7 and then install my version again ?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Backup with wrong special characters

Post by ViktorV » Thu 04 May 2017 11:49

Yes, after testing you can unintall UniDAC 7.0.1 and install UniDAC 4.6.12 again.

mmmmuuuaaaaahhhaaa
Posts: 3
Joined: Wed 03 May 2017 13:30

Re: Backup with wrong special characters

Post by mmmmuuuaaaaahhhaaa » Thu 04 May 2017 12:46

Thx for your support, with the latest UniDac Version 7.0 it´s working.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Backup with wrong special characters

Post by ViktorV » Thu 04 May 2017 13:31

Thank you for being interested in our products. We are always working on performance improvements for our products to meet our users' requirements.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.

Post Reply