Backup with UTF8 vs. UTF8+BOM
Posted: 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.
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.