From: Rich <rich@...>
Date: 2004-06-26T23:58:13+09:00
Subject: Re: SQLite-Ruby and "other chrs"

I require the module 'base64' and then encode64 everything that could have
funky characters before I put it in the DB.

Obviously to get it out you'd want to decode64 everything that was encoded.

This will let you put binary files into sqlite as well, since there's no
'BLOB' column type.

whyTHEluckySTIFF's tutorial got me started...

http://whytheluckystiff.net/articles/aQuickGuideToSQLite.html

-Richard

----- Original Message ----- 
From: "Meino Christian Cramer" <Meino.Cramer@gmx.de>
To: "ruby-talk ML" <ruby-talk@ruby-lang.org>
Sent: Saturday, June 26, 2004 6:05 AM
Subject: SQLite-Ruby and "other chrs"


> Hi,
>
>  a problem with "other chars" hits me... :)
>
>  I try to read a database of shortwave broadcasters (formatted ascii)
>  into a SQLIte-Ruby database.
>
>  The initialization is ok, but from time to time the population of the
>  db breaks, cause some broadcasters station names include invalid
>  chars like
>
>    R.N'Djamena
>
>  and the "'" kills everything.
>
>  Escaping that character in the textfile, which is read to populate
>  the db, doesn't work, cause "\'" ist read as "\" + "'", which
>  again is one "'" to much.
>
>  With mysql there was a method called ".Mysql_escape_string" which
>  does this job. In the SQLite and SQLite-Ruby docs I haven't found
>  anything similiar...
>
>  How can I solve this problem?
>
>  Kind regards and thank you very much in advance,
>  Meino
>