Unicode character showing as ? in NodeJS

Question

I tried to query some Unicode content in MySQL to NodeJS page. I tried to set db and table collate to utf8_general_ci. This is how my connecting creation looks like:

var connection = mysql.createConnection({
                host     : helpers.config.database.host,
                user     : helpers.config.database.username,
                password : helpers.config.database.password,
                database : helpers.config.database.database,
                charset : 'utf8_general_ci'
                });

But almost the unicode characters become '?', Any solution for this?

This is how it looks -

Try utf8_unicode_ci. If it works, let me know. I will add it as an answer :) — Techidiot, Sep 26 '16 at 08:26
Are you sure that your database/table uses utf-8? The standard is latin1_swedish_ci and this one can't handle utf-8. — Joerg, Sep 26 '16 at 08:26
`utf8_general_ci` is not a ***charset***, it's a *collation*. The charset you typically want is `utf8mb4`, or `utf8` if you're on a very old MySQL version. — deceze, Sep 26 '16 at 09:14

score 0 · Answer 1 · answered Sep 26 '16 at 09:09

0

You should also set charset in response as follows. Check if your database/table uses utf8 as @Joerg suggested first.

response.writeHead(200, {'Content-Type': 'text/html; charset=utf-8'});

answered Sep 26 '16 at 09:09

msaint

91
7

Unicode character showing as ? in NodeJS

1 Answers1