Parse UTF-8 encoded JSON from DB into JS

Question

I have the following column in my database with UTF-8 encoded letters:

chineseWords

nǐ hǎo

console.log(value) gives: null

If I change them to non UTF-8,

chineseWords

ni hao

console.log(value) gives: ni hao

If I just keep one word

chineseWords

nǐ

console.log(value) gives: n?

jQuery:

function getData (functionToRun) {  
    $.getJSON("phpscripts.php", {"_functionToRun" : functionToRun},
        function (returned_data) {                      
            var value = returned_data.chineseWords;         
            console.log(value);
        }
    );
}

PHP:

$qry = 
    'SELECT * 
    FROM tasks
    WHERE npc_id_fk = 1';

$result = $mysqli->query($qry) or die(mysqli_error($mysqli));

while ($row = $result->fetch_assoc()) {
    echo json_encode($row);
}

Why would the browser be outputting null and n??

EDIT: following this blog on encoding and decoding UTF-8, I tried:

console.log(decodeURIComponent(value)); //output: n?

EDIT 2:

Connect:

<?php 
$mysqli = new mysqli("localhost", "root", "", "my_db");

if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: (Error code: " . $mysqli->connect_errno . ")... " . $mysqli->connect_error;
}
?>

Start of my phpscripts.php file:

<?php
include 'runDB.php';
mysql_set_charset($mysqli, "utf8");

index.php:

<!DOCTYPE html>
<html>
    <head>
        <title>Playground</title>
        <meta charset="UTF-8">

Maybe try making a native XHR request and look at the response text to see if it's what you expected. — cookie monster
– cookie monster, Commented May 15, 2014 at 1:12

dmo · Accepted Answer · 2014-05-15 01:17:13Z

1

In your HTML Header add:

<meta charset="UTF-8">

In your PHP Mysql call add:

mysql_set_charset('utf8',$connectToDBVar);

after your db mysql_connect but before your query

answered May 15, 2014 at 1:17

dmo

5,3713 gold badges27 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Parse UTF-8 encoded JSON from DB into JS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related