Re: [sqlite] How do I handle special characters?

Joe Lanier wrote: > I am in the process of moving data from flat files to a sqlite > database. I first search through a row and replace ' with '' for > such occurrence as o'riley/joe's. My assumption was that for each > column I could bookend each column with a ' like '123' and that will > allo

[sqlite] How do I handle special characters?

I am in the process of moving data from flat files to a sqlite database. I first search through a row and replace ' with '' for such occurrence as o'riley/joe's. My assumption was that for each column I could bookend each column with a ' like '123' and that will allow the data to pass to the prop