From: Meino Christian Cramer <Meino.Cramer@...>
Date: 2004-06-27T00:57:06+09:00
Subject: Re: SQLite-Ruby and "other chrs"

From: Rich <rich@lithinos.com>
Subject: Re: SQLite-Ruby and "other chrs"
Date: Sat, 26 Jun 2004 23:58:13 +0900

I dont want to encode64 everything (nearly 3197507 normal chars) to
avoid problems of a handful "'"s...

There must be another solution.

> 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

  I read this...

> -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
> >
> 
>