mySQL and accented chars revisited

[John Dixon]

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 :-)