mySQL and accented chars revisited

John Dixon dixonja at
Wed Nov 4 19:33:26 EST 2015

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 "" & 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        
end if    

if I change 
 put temp into theFixtures
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 :-)

More information about the use-livecode mailing list