Android Question PHP and JSON

[sirjo66]

Hello to all,

I am developing an APP that needs to read datas from a MySQL database and I am using some PHP script in the PC server for to read datas from the table and then the result is send to B4A in JSON format.

All works fine, but when in a field there is a string with UTF-8 char, it don't work

The problem isn't B4A, but is that PHP don't work properly.

I have found the solution, I need to use this command in PHP script:

echo json_encode($myarray, JSON_UNESCAPED_UNICODE);

but it works only on PHP version 5.4 and upper, and my servers are running with version 5.3.xx and I can't update it

How can do it ??

And when I solve the problem, and the string "papà" is send as "pap\uxxxx", B4A will work properly ???

Thanks
Sergio

 

[Spinter]

prova a guardare il mio magari puo aiutarti
try to look at my maybe can help you
http://www.b4x.com/android/forum/threads/app-login-con-mysql.26498/#post153375

 

[sirjo66]

Found the problem !!

The MySQL database is encoded by utf8_general_ci, but when I execute a query, the datas is in ISO-8859-1

Why ??

Sergio

 

[Shahid Saeed]

Found the problem !!

The MySQL database is encoded by utf8_general_ci, but when I execute a query, the datas is in ISO-8859-1

Why ??

Sergio

You must save the PHP/JSON File in to UTF-8 without BOM. You will have file Encoding Option while saving the file within your PHP Editor.

 

[sirjo66]

My PHP script is already in UTF-8 without BOM format, but the problem is the same

 

[Erel]

It is not related to the PHP file encoding.

There are several places you need to check. Use PhpMyAdmin to check the server settings and add this line to your script:

mysql_query("SET CHARACTER SET utf8");

 

[sirjo66]

It works !!

Many many thanks
Sergio