Jump to content
Sign in to follow this  
mephtik

Import of MySQL blob cuts off at 128K

Recommended Posts

I have a script that imports several fields from a MySQL DB, including a blob type, which goes into a container in FileMaker.

However, it only gets the first 128KB of data from the blob. Any thoughts?

Share this post


Link to post
Share on other sites

What is in the blob you're attempting to import? I've seen image files that seem fine in My SQL (or other database applications) turn out to be damaged upon closer inspection. Apparently FileMaker is a little more touchy then My SQL when it comes to damaged image files. I'd try inserting the file manually into the container field first to make sure its not choking on the file itself.

Also try duplicating the issue in a new FileMaker file. Damaged files can perform in the strangest of ways.... I've done this in pro 8 with no issues, however I've not attempted in 8.5 or 9.

Share this post


Link to post
Share on other sites

We're using a web form to allow clients upload files to us... sometimes they're jpg, sometimes zip, sometimes another format.

Using a script, I can look at / download any of the files directly from the web through a browser, but as soon as I import them into FM, they mess up.

Share this post


Link to post
Share on other sites

I have the same problem (Post#257377).

Has any Mac OSX User tried the same thing? So we would knew if the problem is due to FM or the ODBC driver.

I called FileMakerInc for this problem, but I'am still waiting for an answer...

Share this post


Link to post
Share on other sites

I'm sure they are talking about an "import from ODBC source", not the ESS feature.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.