On Mon, Sep 21, 2009 at 9:35 AM, Jimmy Verner <jver...@vernerlegal.com> wrote: > I did realize a couple of points that might be helpful to others: > > 1. When you run "find and replace," it won't always pick up all the > apostrophes (or single close-quotes). Apparently, different programs > encode this symbol differently. I've encountered this problem before > when using more than one program to prepare word-processed documents. > There is no easy solution to it that I know of. At times, in formal > documents, I have been reduced to careful proofing to make sure all > the apostrophes are in the same typeface. > > 2. In the particular app I am building, search results are displayed > in html. Replacing apostrophes with ’ ( see > http://tlt.its.psu.edu/suggestions/international/web/codehtml.html#punc > ) solves the problem. Although with this particular database, I > must find and replace all the apostrophes (I'm far enough along with > this database that find-and-replace will be faster than starting > over), in the next one I will replace apostrophes with ’ while > editing in html to finesse the problem.
You shouldn't even be bothering with all of the above if you are creating an application yourself, which, I am assuming you are since you are on this mailing list. You should be using bind values. > > Jimmy Verner > www.vernerlegal.com > >> >> On Sep 20, 2009, at 6:47 PM, Simon Slavin wrote: >> >>> >>> On 21 Sep 2009, at 12:30am, Jimmy Verner wrote: >>> >>>> person's >>> >>> You're using single quotes to surround the text, and there's an >>> apostrophe in the middle of the text. I make this mistake a lot with >>> PHP and it's really annoying. >>> >>> Simon. >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
