Backup with UTF8 vs. UTF8+BOM

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
davor.TCS
Posts: 29
Joined: Thu 05 Apr 2012 22:10
Contact:

Backup with UTF8 vs. UTF8+BOM

Post by davor.TCS » Thu 04 May 2017 18:36

I have upgraded MyDAC from 8.7.27 (21-Nov-2016) to 9.0.1 (05-Apr-2017).
When using BackupToFile with TMyDump now I get file encoded to UTF8+BOM instead of UTF8. How ever when I do RestoreFromFile from earlier made backup (only UTF8 encoded file) in MySQL DB i get strange and unusable characters: BeÅ¡lin DuÅ¡anka instead of Bešlin Dušanka.
I can not say to my customers to delete all of their backups, or to encode them in UTF8+BOM. They dont know to do that.

Please, is it possible for you to change this behavior in this version to default in version 8.7.27? Or suggest some code to overcome this.

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

Re: Backup with UTF8 vs. UTF8+BOM

Post by ViktorV » Fri 05 May 2017 12:45

Thank you for the information. We have reproduced and fixed the issue. This fix will be included in the next build of MyDAC.

Post Reply