Therefore when I have use ODBC and define as a BLOB deosn't works on FileMaker Pro Adv.
And couldn't define any field type in table on FileMaker Pro Adv. when I have use ODBC MySQL.
FileMaker's SQL does not support Blob files. But you can get around it by converting the image to Base64 and using a text field to exchange the data between the two systems and convert back on the receiving end. It sure would be nice if a FM Container field could work as a blob file, but it just doesn't. Maybe in the future.
Are you using ESS? Then binary BLOBs are not supported
Datatypes and Field Mapping with FileMaker | FileMaker
of course. What should I do?
You mean I should define it's to text type on ODBC?
And how can I add picture on FileMaker browse mode?
In MySQL, you will need a process to convert the blob to Base 64 and store it in a text field. FM then reads the Base 64 file and in FM you can put it back together as a binary. It is not elegant, but will work if need it to.
I'll following you and it can show picture or just text on FM browse mode?
As Taylor mentioned. Use Base64-encoded text. Then in FM use a global container (or a real container) to show the base64 de-coded text as a real file/picture/...
You can use MBS FileMaker Plugin to connect to MySQL directly (Without ESS) and run INSERT commands there using BLOB parameters. We do have extra commands to set Parameters with BLOBs from containers.
see documentation page
Monkeybread Software - MBS Filemaker Plugin: SQL.SetParamAsContainer
I used ESS by DNS.
Now I couldn't define any field type on FM.
I just can only define in ODBC MySQL. but when I define blob on MySQL It's not support on FM.
My program need to add picture and show picture on FM browse mode.
The Base64 method is the way to go if you want to avoid a plugin, or you can use the plugin. Have you tried either one?
Retrieving data ...