DBGrid not supporting Chinese Characters

[sfdoony]

Hi Gurus,

Just in the recent I started to develop a program with Lazarus. In DBGrid component, Chinese character always shows as question mark '?'. For example, if the value in database is 你好, showing ??. And, if entering Chinese, it will show question mark/? right away, and question mark will be posted to database.

Here attached the screenshot. In Text and Label can edit/display Chinese characters correctly.

I found in some earlier posts there mentioned converting Chinese when retrieving from database and posting to database. But those are not my case.

I've updated my Lazarus to latest version 4.2.

OS is Windows 10 x64.

Could you please advise or share your experience?

Much appreciated.

[wp]

Which database type are you using?

How are the strings in the Label and the Edit extracted from the database?

When you type Chinese strings in your source code, will they be displayed correctly?

[sfdoony]

Hi WP,

Sorry my bad, I forgot to explicitly maintain the charset in MySQL57Connection to utf8mb4.

Earlier, elsewhere except DBGrid, Chinese can be displayed correctly.

Now, all good.

Thank you.