search for: blobvar

Displaying 1 result from an estimated 1 matches for "blobvar".

Did you mean: globvar
2007 May 25
7
Storing large BLOBs in the database with ActiveRecord
...sql server(max_allowed_packet) to hold the commands must be at least 16MB (two bytes for hexadecimal representation). This is an unecessarily huge number for holding SQL commands. Is there a way to tell ruby to use a host variable in the SQL statement (i.e. VALUES(''PROD1'', 4.56, :blobvar) instead of the literal format in the example above. I cannot believe this problem has never been seen before? Imagine if the BLOB data I need to store is 100MB? Your help is much appreciated. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You...