json utf-8 encoding for android

Question

i have some persian(utf8) words on my database for my android app and i am using json for show database information in android app.
I have following code on Databasemanager.php:

function getMusics()
{
    $connection = mysqli_connect(DatabaseManager::HOST_NAME, DatabaseManager::USER_NAME, DatabaseManager::PASSWORD, DatabaseManager::DATABASE_NAME);
    $sqlQuery = "SELECT * FROM musics where active = 1 order by date desc;";
    $result = $connection->query($sqlQuery);
    $musicsArray = array();
    if ($result->num_rows > 0) {
        for ($i = 0; $i < $result->num_rows; $i++) {
            $musicsArray[$i] = $result->fetch_assoc();
        }
    }
    echo json_encode($musicsArray);
}

and in GetMusic.php for get json information :

<?php
include "DatabaseManager.php";
$databaseManager = new DatabaseManager();
$databaseManager->getMusics();

but i have bellow jsons on output :

{"id":"3","name":"???","artist":"????? ????","like_count":"1","comment_count":"0","dl_link":null,"photo":"http:\/\/192.168.88.6\/musicarea\/photos\/3.jpg","active":"1","date":"2017-08-04 00:00:00"}

how can i solve it ??

on output(i just use persian language at 2 last rows): on the app:

on php my admin:

have you tried setting UTF-8 as default encoding for all MySQL connections? — Droidman
– Droidman, Commented Aug 31, 2017 at 7:28
@emen try using de2.php.net/manual/en/mysqli.set-charset.php — Droidman
– Droidman, Commented Aug 31, 2017 at 7:44

Community · Accepted Answer · 2023-11-17 19:32:19Z

1

You should set the default client charset to UTF-8. Use mysqli::set_charset OR mysqli_set_charset.

See https://www.php.net/manual/en/mysqli.set-charset.php for more info.

edited Nov 17, 2023 at 19:32

CommunityBot

11 silver badge

answered Aug 31, 2017 at 8:16

Droidman

11.6k17 gold badges96 silver badges148 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Basil Battikhi · Accepted Answer · 2017-08-31 07:23:23Z

1

You have to add the header that it tells the client the response is encoding with utf-8

header('Content-Type: text/html; charset=utf-8');

answered Aug 31, 2017 at 7:23

Basil Battikhi

2,6682 gold badges23 silver badges36 bronze badges

5 Comments

emen Over a year ago

Where should I use this? i added in bellow of <?php in both files but didnt works...

Basil Battikhi Over a year ago

add it before the response is firing

Droidman Over a year ago

it should be header("Content-type: application/json; charset=utf-8"); assuming that the strings stored in the database are actually utf-8 incoded strings, won't work otherwise

Basil Battikhi Over a year ago

Sure, also the response should be received as utf8

emen Over a year ago

@BasilBattikhi ok w8

Orvenito · Accepted Answer · 2017-08-31 07:39:03Z

1

EDIT

function getMusics()
{
    $connection = mysqli_connect(DatabaseManager::HOST_NAME, DatabaseManager::USER_NAME, DatabaseManager::PASSWORD, DatabaseManager::DATABASE_NAME);
    $sqlQuery = "SELECT * FROM musics where active = 1 order by date desc;";
    $result = $connection->query($sqlQuery);
    $musicsArray = array();
    if ($result->num_rows > 0) {
        for ($i = 0; $i < $result->num_rows; $i++) {
            $musicsArray[$i] = $result->fetch_assoc();
        }
    }
   header("Content-type: application/json; charset=utf-8");
    echo json_encode($musicsArray);
}

edited Aug 31, 2017 at 7:39

answered Aug 31, 2017 at 7:34

Orvenito

4372 silver badges14 bronze badges

2 Comments

emen Over a year ago

header('Content-Type: text/html; charset=utf-8'); echo json_encode($musicsArray); ??

Orvenito Over a year ago

try this one bro json_encode($musicsArray, JSON_UNESCAPED_UNICODE);

Collectives™ on Stack Overflow

json utf-8 encoding for android

3 Answers 3

Comments

5 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related