Blob fields (pictures) are ignored when converted to MySQL
Posted: Fri 12 Sep 2014 15:01
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 :
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
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 MyTableAny idea of how to convert a table to mySQL getting also the picture ? myTable as 9000 records of picture ?
Regards