BLOB field AS HEX (HexBlob) problem

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
m227
Posts: 75
Joined: Mon 06 Aug 2007 12:41

BLOB field AS HEX (HexBlob) problem

Post by m227 » Thu 05 Nov 2015 17:06

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

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

Re: BLOB field AS HEX (HexBlob) problem

Post by ViktorV » Mon 09 Nov 2015 13:26

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.

Post Reply