In MySql database has a table in which one of the columns uses UTF - 8 fromat for special characters. When they are to display in the datagridview they are showing "?"


When dataGridView have to display name of some compounds like "2,4-Di-epi-Soraphen A1α", "Soraphen A1β" , instead they are showing "2,4-Di-epi-Soraphen A1?", "Soraphen A1?" . In MySql table they used UTF - 8 characters like (Β,µ,α) . while displaying it in datagridview they are following "?" format when ever they encounter them.

Can any one suggest me how to do it please?

I believe the problem is SQL side not VS side

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.