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

Mon Oct 3 13:40:41 EDT 2011

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 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 want to check the charset of your sql database itself. If you don't ever expect to use a foreign language or exotic characters, then UTF8 should work fine. 

A second way to avoid problems is to store your datas as "the HTMLText of field n" (the HTMLText is a property and don't apply to var contents. See the dictionary for the details)
> 
> Bob
> 
> 
> On Oct 3, 2011, at 9:29 AM, John Patten wrote:
> 
>> 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 correctly, apostrophes are apostrophes, question marks are question marks. However, when I pull the data from the database using an .irev script and display as html in web browser, apostrophes are not correct (questions marks in black box, or if I change the charset in the header of the irev script, a completely different non-english character appears.)
>> 
>> How do I get my irev script to save content to database correctly, and get data displayed correctly when displaying in html in web browser?
>> 
>> I have messed with changing the charset in header, i.e :
>> 
>> <head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
>> </head>
>> 
>> ...in my irev script, but changing the charset only results in different characters. It's almost as if I have not found the correct charset? But yet, if my LC project pulls the content from the DB everything appears as it should???
>> 
>> Thanks for any tips!
>> 
>> John Patten
>> SUSD
>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.com