dotConnect for MySQL can't display Chinese Character
Hi,
trying to evaluate if the dotConnect is useful for my project, I downloaded the free version.
managed to get the thing to work after jumping through many many many hoops. (Like, it doesn't work in VS2022, had to hunt down a copy of VS2019 to get it working)
Now the problem is, whenever I tried to display Chinese characters in my data table, they all came out as garbage characters.
I tried setting the Character Set in the connection settings to UTF8, UTF8-MB4, GBK and GB2321, non of them worked. (My tables are in UTF-MB4 encoding)
How do I make the characters display properly? TIA.