Re: On-Rev: irev to mysql to html charset (apostrophes, etc.) confusion?

In Sybase and in Python, if you enclose your text statements in double quotes, you must escape double quotes inside the text string and don't have to escape single quotes. Similarly, if you enclose using single quotes, you must escape the single quotes inside the text string and don't have to es

Re: On-Rev: irev to mysql to html charset (apostrophes, etc.) confusion?

In SQLite, the way to escape an apostrophe is to precede it with another apostrophe, not a backslash. mySQL allows either method, not sure about other SQL implementations. Pete Molly's Revenge On Mon, Oct 3, 2011 at 10:40 AM, Pierre Sahores wrote: > > Le 3 oct.

Re: On-Rev: irev to mysql to html charset (apostrophes, etc.) confusion?

Le 3 oct. 2011 à 18:42, Bob Sneidar a écrit : > How are you escaping your sql? If not, it needed where "it's needed" becomes "it\'s needed" to be stored in your SQL backend. > Are you using the same method in your web app? If you are not, then I think > this is probably the issue. I use sqlYo

Re: On-Rev: irev to mysql to html charset (apostrophes, etc.) confusion?

How are you escaping your sql? Are you using the same method in your web app? If you are not, then I think this is probably the issue. I use sqlYoga and if I am not mistaken, it has it's own built in escaping. You may want to have a chat with Trevor Devore about this sort of thing. You may wan

On-Rev: irev to mysql to html charset (apostrophes, etc.) confusion?

Hi All! I have a LC project that pushes data to a on-rev mysql database. The data saves to the mysql fine, however, apostrophes and other some other punctuation get saved as "non-english" characters. If I request the data from the database via my LC project, everything gets pulled back correct