Problems with international characters

[Omar_Ivan_Reyes_Ortiz]

I am having troubles with bringing international characters from a MySQL database via PHP through my App.

The PHP code that I use to send data to my app is this:

Image edited by Mod

The result is this

but when I populate a list picker in my app, the information the result is this

Can anybody help me, please

[Boban (Boban Stojmenovic)]

I’ve edited your image for your safety.

@Taifun This is your expertise.

[Omar_Ivan_Reyes_Ortiz]

Thanks a lot

[Taifun]

see if one of the answers in Q3 can help
https://puravidaapps.com/mysql.php#q
Taifun

[Omar_Ivan_Reyes_Ortiz]

Thanks, I will check now

[OfficialDjJohn (DjJohn)]

@Boban

@Taifun This is your expertise

Since Boban asked Taifun about this problem…
I was like when will Taifun reply for this ,
At that time Costa Rica time was 12:40 am
.
And after reply

@Taifun

App Inventor Tutorials and Examples: MySQL | Pura Vida Apps

I studied this link
I found

.
So the purpose of this reply is to ask where should I use *mysqli_set_charset($dbc, “utf8”);
?
I was having same problem…

[Taifun]

@OfficialDjJohn

So the purpose of this reply is to ask where should I use *mysqli_set_charset($dbc, “utf8”);
?
I was having same problem…

well… obviously in the php script…
for example like this after creating the connection

$conn = new mysqli($DB_ADDRESS,$DB_USER,$DB_PASS,$DB_NAME);    
mysqli_set_charset($conn, "utf8");                                            

if($conn->connect_error){   ... 

Taifun

[OfficialDjJohn (DjJohn)]

ohh dumb me…
Thank you very much… I’ll try it…

[Omar_Ivan_Reyes_Ortiz]

@Taifun

mysqli_set_charset($conn, “utf8”);

Dear Taifun,
It works fine!! Thanks a lot.
Pura vida!!