Known Participant

Answered

[Chinese] display problem, on retrieving data from database

8 replies
604 views
Translate

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

may i know any coding problem?

Server side applications

This topic is closed to new replies. Start a new post to keep the conversation going.

Nancy OSheaCorrect answer

Community Expert

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

Nancy O'Shea— Product User & Community Expert

Nancy OShea

Community Expert

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.

Translate

Nancy O'Shea— Product User & Community Expert

Nancy OShea

Correct answer

Community Expert

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

Translate

Nancy O'Shea— Product User & Community Expert

Nancy OShea

Community Expert

See if this helps you.

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

Translate

Nancy O'Shea— Product User & Community Expert

H

Hiu Ching26169588pka2Author

Known Participant

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

Translate

BenPleysier

Community Expert

You should use utf8mb4 instead.

Translate

Wappler is the DMXzone-made Dreamweaver replacement and includes the best of their powerful extensions, as well as much more!

H

Hiu Ching26169588pka2Author

Known Participant

i already chose utf8mb4

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.