Combine two MySQL fields (TEXT with BLOB)

Hi,

We have a BLOB that we want to access with a reporting tool without decent converter to read these Binary file.

1. We have a table with two fields that we want to combine to one field (see example)


2. This job has to be scheduled every night after a data-cube is produced for reporting


3. The database is MySQL on a Linux system (but we also run windows like configs)

Record	Table A : Field (File_name)	Table A : Field (BLOB)	Table A : Field (new File_name + BLOB)
1	Name1.ext	Binary.i4 / download	Combine to Name1.ext / download
2	Name2.ext	Binary.i4 / download	Combine to Name2.ext / download
...	NameX.ext	Binary.i4 / download	Combine to NameX.ext / download

Kind regards
Frank
Request received by Email

Hi Frank,

Sorry I don`t know what´s your purpose :unsure:

First of all you cannot mix TEXT (char, varchar) with BLOB (binary) values. For BLOB (binary values) the certain application has to know how the data should be interpreted. For example the data can be an Excel or Word document a picture (jpg, png, bmp) or something else. Of course FlowHeater can build a TEXT field with the filename + base64 or Hex coded binary values.

e.g.
Hex coded: filename.txt – 0xA10104B2….
Base64: filename.txt - 8apAi...aqeQ==

The text content (string) of such field can be very long and I guess this is not what you really need?

It would also be possible to store the BLOB (binary) field into a file and save the whole path into the certain field.

Please describe a bit more in detail your needed solution.

Question 2) You can run every FlowHeater Definition automated with Batch Module and a Windows scheduled task. Here you’ll find a short example how it works: Automated batch CSV import into MS Access

Question 3) FlowHeater can access MySQL databases on Linux systems as well. Just the Designer or the Batch module has to run on Windows.