Saving gzipped string into Sqlite3 via Rails throws unrecognized token error
Posted
by user141146
on Stack Overflow
See other posts from Stack Overflow
or by user141146
Published on 2010-03-26T04:39:14Z
Indexed on
2010/03/26
4:43 UTC
Read the original article
Hit count: 343
Hi, 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)?
Relevant code is below.
# compress my text
require 'zlib'
defl = Zlib::Deflate
test_string = "<h3>some text</h3>some additional text<p>here's some more text</p>"
compressed_string = defl.deflate(test_string)
=> "x\234\263\3110\266+\316\317MU(I\255(\261\321\207\361\022SR2K2\363\363\022s \022\005v\031\251E\251\352\305\n`\331\334\374\"\230\206\002;\000\0225\027\222"
ModelClass.new(:attribute1 => compressed_string).save
ActiveRecord::StatementInvalid: SQLite3::SQLException: unrecognized token: "'x#####+##MU(I#(#?####2K2#### v#E####
© Stack Overflow or respective owner
