Prev: Saving gzipped string into Sqlite3 via Rails throws unrecognized token error
Next: user input timeout.
From: Jonathan Nielsen on 26 Mar 2010 01:51
On Thu, Mar 25, 2010 at 11:30 PM, pablitoman <thebusyant(a)gmail.com> wrote:
> Not sure if this belongs in the rails forum or here (it's a little of
> both)...
>
>  I'm using rails 2.3 and I'm trying to compress (gzip) text that I'd
> like to save using ActiveRecord into a sqlite database.
>
> However, the compressed text isn't being saved b/c I get this type of
> error: SQLite3::SQLException: unrecognized token: "'x##Uˎ#7
>
> Any thoughts on what I can do to avoid this error?
>
> should I compress the text in some other fashion?
> should I save the data using some other method(s)?
> TIA!!!

I have no idea if this is what is going on because I haven't worked
much with SQLite, but are you saving to a TEXT field or a BLOB field?
If the field is TEXT, try making it a BLOB and see if that works.

-Jonathan Nielsen

 | 
Pages: 1
Prev: Saving gzipped string into Sqlite3 via Rails throws unrecognized token error
Next: user input timeout.