Page 1 of 1

mySQL and accented chars revisited

Posted: Thu Nov 05, 2015 1:46 am
by 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