BLOB field AS HEX (HexBlob) problem
Posted: 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
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
			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
so now:8.5.15 17-Jun-15
Bug in TMyDump when data type mapping is used is fixed
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