Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Combine two MySQL fields (TEXT with BLOB)

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
8 years 6 months ago - 8 years 6 months ago #2436 by FlowHeater-Team
Combine two MySQL fields (TEXT with BLOB) was created by FlowHeater-Team
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)
RecordTable A : Field (File_name)Table A : Field (BLOB)Table A : Field (new File_name + BLOB)
1Name1.extBinary.i4 / downloadCombine to Name1.ext / download
2Name2.extBinary.i4 / downloadCombine to Name2.ext / download
...NameX.extBinary.i4 / downloadCombine to NameX.ext / download

Kind regards
Frank
Request received by Email

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Last edit: 8 years 6 months ago by FlowHeater-Team.

Please Log in to join the conversation.

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
8 years 6 months ago - 8 years 6 months ago #2437 by FlowHeater-Team
Replied by FlowHeater-Team on topic Combine two MySQL fields (TEXT with BLOB)
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.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Last edit: 8 years 6 months ago by FlowHeater-Team.

Please Log in to join the conversation.

Time to create page: 0.330 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.