Skip to main content
Known Participant
July 3, 2023
Answered

[Chinese] display problem, on retrieving data from database

  • July 3, 2023
  • 3 replies
  • 565 views

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

may i know any coding problem? 

This topic has been closed for replies.
Correct answer Nancy OShea

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

 

 

 

3 replies

Nancy OShea
Community Expert
Community Expert
July 20, 2023

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 O'Shea— Product User & Community Expert
Nancy OShea
Community Expert
Nancy OSheaCommunity ExpertCorrect answer
Community Expert
July 21, 2023

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
Community Expert
July 20, 2023
Nancy O'Shea— Product User & Community Expert
Known Participant
July 3, 2023

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
Community Expert
Community Expert
July 3, 2023

You should use utf8mb4 instead.

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

i already chose utf8mb4