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 >> [email protected] >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > [email protected] > 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 _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
