mySQL and accented chars revisited

[Dixie]

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

Code: Select all

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

Code: Select all

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

Code: Select all

put temp into theFixtures

to

Code: Select all

]put textdecode(temp,"UTF-8") into thefixtures

then 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

LC 7.1, xCode 6.4