Datagrid font display problem.
 

Dear members,

Thank you in advance :icon_smile:

I have a DataGrid (MS DataGrid control (SP6) (OLEDB) ) in a form. It is bound to the DataSource through code. I am using the latest MySQL database (utf8). Using Windows 2000 server SP4 and Windows XP.

Problem:
My problem is that the DataGrid displays garbage characters in some columns and the difficult part is that it is only happening in some computers. In one PC it is displaying all columns properly, but in the other its showing some chinese character and a square box.

What I tried:

1. I checked the font settings in regional properties, even the default font for non-unicode programs.
2. Tried with different fonts in the DataGrid
3. Tried with different character set for that specific MySQL table

:?: Can anyone kindly show some light in this regard. Is it due to VB6 or Windows settings or MySQL configuration? Any solutions? :idea: