weblistbox does not display non-english characters

General
#1

Hi,

I am running a web app from Xojo Cloud, which reads data from MySQL database.
Under the “Username” field some data is in a different language, i.e. non ascii character, and as a result I get an error message.
Is there a way to display these characters in a weblistbox cell, or at least identify the non-ascii characters and omit the record?

Thank you

#2

Make sure when you read the text from the database that you are setting the encoding properly.

#3

Hi Greg,

After your suggestion and a bit of surfing in the forum I came accross a discussion titled
App json exception
where the solution was to add the following 2 lines before any database queries:
{db connection object}.SQLExecute(“set names utf8 collate utf8_general_ci”)
{db connection object}.SQLExecute(“set character set utf8”)
That did it!

Thank you guys for the support and the informative forum.
Take care

#4