TMyDump and unicode

ben · Post by **ben** » Sun 10 Sep 2006 15:27

I've notice that TMyDump is unable to properly backup a table that contains unicode characters. The result SQL or file contains no unicode.

is that a bug?

Antaeus · Post by **Antaeus** » Mon 11 Sep 2006 12:19

You can work with TMyDump and Unicode with following settings:
Connection.Options.Charset = utf8;
Connection.Options.UseUnicode = False;

ben · Post by **ben** » Mon 11 Sep 2006 18:25

yes that is what I did but the SaveToFile option saves the file in a non unicode format. Have you tested?

Antaeus · Post by **Antaeus** » Tue 12 Sep 2006 13:49

Yes, we have tested this issue. String values are saved in utf8 format. To run this SQL script you should execute SET NAMES utf8 command previously.