From: pablitoman <thebusyant@...>
Date: 2010-03-26T16:40:06+09:00
Subject: Re: Saving gzipped string into Sqlite3 via Rails throws unrecognized 	token error

On Mar 26, 1:51 am, Jonathan Nielsen <jonat...@jmnet.us> wrote:
> On Thu, Mar 25, 2010 at 11:30 PM, pablitoman <thebusy...@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

Sorry, you were right.  I had a bug in my code when I was testing your
suggestion.  converting the columns to blob worked perfectly.

TKS!