PHP - Database results encoding?

Question

i have the following function to obtain a language strings, it works fine for english but not for portuguese characters.

public function GetAllLanguageStrings($langid)
    {
        $GLOBALS['mysqli']->query("use " . $GLOBALS['db_name']);
        $stmt = $GLOBALS['mysqli']->prepare("SELECT lang_identifier, text FROM lang_strings WHERE lang_id = ?");
        $stmt->bind_param("i", $langid); 
        $stmt->execute();
        $stmt->bind_result($identifier,$text);
        $result = array("LangStrings" => array());

       while ($stmt->fetch()) {
            array_push($result['LangStrings'], array("Identifier" => $identifier, "Text" => $text));
        }

        return json_encode($result, JSON_PRETTY_PRINT);
        $stmt->close();
    }

the results turn out to be wierd

{ "Identifier": "LOGIN_INFORMATION", "Text": "Informa\u00e7\u00f5es de Login." }

instead of

{ "Identifier": "LOGIN_INFORMATION", "Text": "Informações de Login." }

i tried to add the following settings:

$mysqli->query("SET NAMES utf8");
$mysqli->query("SET CHARACTER SET utf8");
$mysqli->set_charset("utf8");

but nothing changed.

Community · Accepted Answer · 2017-05-23 11:54:47Z

1

The JSON_UNESCAPED_UNICODE flag might be what you are looking for.

Please refer to this explanation for details on how json_encode outputs data and how to manipulate the output by setting the right flags.

edited May 23, 2017 at 11:54

CommunityBot

11 silver badge

answered Nov 2, 2015 at 20:10

Stefan Dochow

1,4541 gold badge10 silver badges11 bronze badges

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

4 Comments

EchO Over a year ago

better than before but still: {"Identifier":"LOGIN_INFORMATION","Text":"InformaÃ§Ãµes de Login."},

Stefan Dochow Over a year ago

well is the text stored as utf8 im the db?

Stefan Dochow Over a year ago

look slike it: fileformat.info/info/unicode/char/00E7/index.htm you actualy end up with the correct encoded value. Does the webserver return utf8 encoded content? check the headers. Is there another charset specified in the document?

EchO Over a year ago

The solution: return utf8_decode(json_encode($result, JSON_UNESCAPED_UNICODE)); still i'm marking your answer as correct because you helped out ;)

TRiG · Accepted Answer · 2017-05-16 14:50:27Z

0

return utf8_decode(json_encode($result, JSON_UNESCAPED_UNICODE));

edited May 16, 2017 at 14:50

TRiG

10.7k9 gold badges62 silver badges113 bronze badges

answered Nov 2, 2015 at 20:32

EchO

1,3641 gold badge10 silver badges17 bronze badges

Collectives™ on Stack Overflow

PHP - Database results encoding?

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related