[Chinese] display problem, on retrieving data from database

[Hiu Ching26169588pka2]

 

My data is entered in english and chinese.
However, the chinese character cannot be shown

may i know any coding problem? 

 

[Nancy OShea]

See if this helps you.

https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html#faq-cjk-what-cjk-avail

[Hiu Ching26169588pka2]

i have set uft8 in my database and coding, but some characters in database still cannot be shown.

May i know how can it solve in coding or should i change to another hosting service

 

 

 

 

[BenPleysier]

You should use utf8mb4 instead.

[Hiu Ching26169588pka2]

i already chose utf8mb4

[osgood_]

My sql database is set to 'utf8_general_ic' - that seems to show Chinese characters for me if I insert some into it to test.

Other things you can try:

Directly AFTER your database connection string add:

mysqli_set_charset($connect , 'utf8');

Make sure you have included the below html meta charset in the head section of your page - it may well already be there, in your inc_head.php file:

<meta charset="UTF-8">

Maybe one of the suggestions will resolve your issue.

[Hiu Ching26169588pka2]

i already have  <meta charset="UTF-8">

[Nancy OShea]

You posted twice about the same topic. So to avoid confusion, I merged them into one discussion for you.  

Did you run SQL query for Chinese results from your database?  That's the first thing I would test.

[Nancy OShea · Accepted solution]

This might be a data organization problem.  I keep second and third language translations in unique database fields for easier querying.