I was using the mysql adapter, and I managed to fix my problem by setting the type of the column to 'mediumblob'. When I said 'big blob' before, I didn't mean anything about the type of the actual column (sorry if that was misleading, it was just a 'blob'). I thought that I had noticed that more than 2^16 bytes were being stored in the column so I was really confused, but I'm thinking this problem was a false alarm. I haven't been able to reproduce the problem, and I've only seen expected results in my attempts to figure out what went wrong. Really sorry!
Alex On Wed, Feb 24, 2010 at 4:03 PM, Jeremy Evans <[email protected]>wrote: > On Feb 24, 1:39 pm, alexebird <[email protected]> wrote: > > Hi, > > > > I'm using Sequel and MySQL for a project, and I've run into a problem > > where only part of the contents of a big blob are returned by Sequel. > > I'm able to see that the entire blob (about166k) is being stored in > > the database, but when the model is loaded, only 66k of the blob is > > returned. Any ideas? Using sequel 3.8.0. > > Are you using the mysql adapter, or one of the other adapters (e.g. > JDBC or DO)? > > If you are using the mysql adapter, can you try accessing the database > directly with ruby-mysql and see if you get the same result? On the > mysql adapter, Sequel doesn't do any processing of blobs returned from > the database, other than wrapping them in a Sequel::SQL::Blob (which > should not do any truncation). > > If you could put together a self contained example, I'd be eager to > looking into it and seeing where the problem is occurring. > > Thanks, > Jeremy > > -- > You received this message because you are subscribed to the Google Groups > "sequel-talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<sequel-talk%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/sequel-talk?hl=en. > > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
