Yes I am using LC7... I should have mentioned that... Peter, thank you for your suggestion, I will try that..:-)
I have just had a thought... How would you go about handling accented chars if you were put in the position of using a mySQL database, belonging to someone else, that had never seen liveCode before ? > Hi John, > Sounds like you're using LC7 since I see textDecode in there. > > I don;t know enough about the URL side of things but I think the issue on > the database side is what you are doing when you INSERT or UPDATE the > data. It needs to be textEncoded at that point. After that, you need to > textDecode it every time you SELECT it. > > If you haven't textEncoded the data, you'll need to write a script that > takes care of that. I haven't tried this but I think if you SELECT every > record in your database without textDecoding it, then textEncode it and > UPDATE it back into the database, that will fix it. Please try this on a > copy of your database, not the live version! > > Once you've done that and added the textEncode/textDecode logic to your > database handlers, I think you'll get your è back! > > Pete > lcSQL Software <http://www.lcsql.com> > Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and > SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> > > On Wed, Nov 4, 2015 at 4:33 PM, John Dixon <dixo...@hotmail.co.uk> wrote: > > > In a mySQL database I have a name... Bordeaux-Bègles > > I call it from the database into a liveCode stack and it comes out as ... > > Bordeaux-BÈgles > > > > from within a card script :- > > > > put "http://www.xxxxxxxx.com/rugbyapp/rugby.lc?A=fixtures&thediv="; & > > theLeague into theURL > > put URL theURL into temp > > put temp into theFixtures > > > > within the corresponding .lc script :- > > > > if tAction = "fixtures" then > > put $_GET["thediv"] into thedivision > > > > get revDataFromQuery( tab, return, theDataRef, "SELECT * FROM fixtures > > where league='" & thedivision & "' ;") > > put it into temp > > put temp > > revCloseDataBase theDataRef > > quit > > end if > > > > if I change > > put temp into theFixtures > > to > > put textdecode(temp,"UTF-8") into thefixtures > > > > the I get Bordeaux-Bgles... the e, never mind the accent does not > > appear... I seem to bang my head against a wall over this time and time > > again... > > > > Help... please... I want my è back :-) > > > > _______________________________________________ > > use-livecode mailing list > > use-livecode@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
