mySQL and accented chars revisited

Getting into LiveCode for iOS? Ask your questions here.

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
Dixie
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 1336
Joined: Sun Jul 12, 2009 10:53 am
Location: Bordeaux, France

mySQL and accented chars revisited

Post by Dixie » Thu Nov 05, 2015 1:46 am

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

Post Reply

Return to “iOS Deployment”