Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Python, Lua and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Java, C, C++, Ruby, MySQL and Linux / Tomcat systems
In Mysql, longblob is not storing more than 200kb

Posted by varunkumargoel (varunkumargoel), 20 September 2007
Hi All,

         I am using ruby on rails as front end and Mysql as back end and now i wanna upload file more then 1MB and in mysql i used longblob for storing the files.
But it's taking only 200 KB if i will upload more then this it is not adding this file into database.

Please help me and tell it's Mysql Error or ROR ?//
If you have solution please tell me soon??

           Waiting for ur reply.Thanks in advance.........................

Varun Kumar Goel

Posted by admin (Graham Ellis), 20 September 2007
Check to see what happens if you upload an image and save it in a file rather than in a database.   If the file you get is just 200k, the you have a RoR issue, but if it's full size then the issue is a database one.   Personal guess - it'll be your RoR or web server upload limits.

This page is a thread posted to the opentalk forum at and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2018: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01225 708225 • FAX: 01225 793803 • EMAIL: • WEB: • SKYPE: wellho