Page 1 of 1

BLOB field AS HEX (HexBlob) problem

Posted: Thu 05 Nov 2015 17:06
by m227
Dear Sirs,
I make db backup using TMyDump. Either I use HexBlob set to false or true I get "int(10) unsigned" fields appear to be ASCII codes (i.e. CHR(12)) instead of numbers (i.e. 12). It cannot be imported then back.
BLOB Fields appears to be "hexized" right. Server: MySQL 5.5.44 (linux, x86_64), Client: Delphi XE2, MyDAC 8.5.14, table: InnoDB.
---------------------------------------------------
OK, I found FIX:
looking at changelog of MySQL DAC i found such entry
8.5.15 17-Jun-15
Bug in TMyDump when data type mapping is used is fixed
so now:
1) I clear DataTypeMap first with MyConnection.DataTypeMap.Clear;
2) dump data with TMyDump
3) add DataTypeMap again...

Do I have possibility to get version bugfixed even if my license ends on 8.5.14?
Michal

Re: BLOB field AS HEX (HexBlob) problem

Posted: Mon 09 Nov 2015 13:26
by ViktorV
You can download 8.6.19 MyDAC Trial Edititon containing the bug fix for using TMyDump with data type mapping. To use the licensed version of MyDAC including this fix, you should renew the subscription at http://www.devart.com/mydac/ordering.html in the Subscription Renewals section the Renewals & Upgrades tab. Then you will be able to download the latest MyDAC version from secure.devart.com using the credentials you got when buying the product.