Blob fields (pictures) are ignored when converted to MySQL

[ads42]

Hi,
I have to port a old project that someone made in FileMaker 11 to Delphi MySQL.
I use dbForge Fusion for MySQL inside Delphi.
I try to convert table from FileMaker 11 (using ODBC) to MySQL, but pictures stored in blob are simply ignored.
In the filemaker site they say that to get the value of a container we have to use this syntax :

Code: Select all

SELECT GETAS(MyPictureField, 'JPEG') AS IMG  FROM MyTable

if not doing this the field appear as empty.
Any idea of how to convert a table to mySQL getting also the picture ? myTable as 9000 records of picture ?
Regards

[alexa]

We are currently investigating this issue and will answer you as soon as possible.

[alexa]

In order to resolve this, we recommend you to refer to some other sources in the Internet, for example:
http://www.filemakertoday.com/com/showt ... mage-BLOBS
http://help.filemaker.com/app/answers/d ... -filemaker