Oliver
Jacob Lund wrote:
Hi Luke!
MySQL has as 64K limit in blob fields! Change the database scheme - replace blob with longblob!
/jacob
----- Original Message ----- From: "Luke Noel-Storr" <[EMAIL PROTECTED]>
To: "Slide Users Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, May 12, 2004 11:12 AM
Subject: Strange problem with files over 64K and Webfolders/Office
Hi,
I have a slide repository set up in MySQL, but with the content stored in a file store (I set it up this way due to problems with large files and MySQL).
There now seems to be a problem with files over 64K, when we access them via our client code - they work fine, when downloaded from a URL, they work fine, when opened in Office, or copied from a webfolder, they cut off at 64K.
Anyone else had this problem? any ideas?
I had initial problems with files over 64K and MySQL in that only the first 64K was being stored in the blob, I then changed the blob fields to long blobs, this worked but caused out of memory exceptions for files over a few MB, so I then changed to storing the content in a file store outside of MySQL, however I'm now having problems with files over 64K in Office and Webfolder. Hair is being torn out and help would be greatly appreciated.
Cheers
Luke. -----
(ps, and many thanks to Ingo and others with my sessions problem; I have now *greatly* reduced the number of sessions being spawned)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
