MyDump BackupToFile() Unrecognizable Code

redlegend · Post by **redlegend** » Sun 19 Jul 2009 09:37

my os is windows2000 chinese
my delphi version is 7
I used mydac 5.8, Tnt Unicode Control

my mysql server charset is utf8

when i use mydump backuptofile('c:\1.sql'), the file c:\1.sql is Unrecognizable Code, some character can recognizable, some is unrecognizable, oh, is a very big problem, who can help me?????

Dimon · Post by **Dimon** » Mon 20 Jul 2009 14:37

To solve the problem you should set the TMyConnection.Options.UseUnicode property to True.

redlegend · Post by **redlegend** » Tue 21 Jul 2009 15:34

Dimon wrote:To solve the problem you should set the TMyConnection.Options.UseUnicode property to True.

I have already set TMyConnection.Options.UseUnicode to True, but the backup file still error coding.

Oh, how to solve this problem????????

Dimon · Post by **Dimon** » Wed 22 Jul 2009 13:14

I could not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.