From: Reimer Behrends Date: 2004-06-27T02:28:06+09:00 Subject: Re: SQLite-Ruby and "other chrs" Meino Christian Cramer (Meino.Cramer@gmx.de) wrote: [...] > 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. Escape single and and double quotes by doubling them, not by preceding them with a backslash. Note that SQLite strings can handle all characters except the NUL character. Reimer Behrends