From: Meino Christian Cramer <Meino.Cramer@...>
Date: 2004-06-26T21:05:02+09:00
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