Chopped files when downloading from database

I have some files stored in db. When I try to download these I only get
65535 bytes from the database even if the file is a lot bigger. Is it a
Rails setting I’ve missed or a database setting? Anything else?

Using Rails 1.0, WinXP and MySQL4.1


On 1/9/06, marcus [email protected] wrote:

[email protected]

You are probably storing in a database column that’s smaller than the
file. I think the TEXT column in mysql is that long. Try switching
to LONGTEXT. Alternately, you could just use file_column.

Kyle M.
Chief Technologist
E Factor Media // FN Interactive
[email protected]

Sorry for not specifying the column type. It’s actually a blob. Is that
also defaulted to 64k? And we don’t want to use file_column since we
want to store in database and not on the file system. If I’m wrong about
this (whether it only stores to file system or not) then I’d be glad to
hear about it.


Found the answer myself. A blob is 16-bit big. I’ll change it to
longblob instead (32bit)

Thanks for the pointer though.


This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs