I’ve connected to MySQL successfully, but it displayed “??” instead of the correct Chinese characters which is the data from MySQL. I’m using the xojo under windows 8.1, and I’ve try to connect the MySQL data with php, it showed the Chinese characters correctly. Can anyone help at this point?
either you use MBS SQL Plugin which uses Unicode API for MySQL.
Or you use built in Xojo MySQL Plugin and do it yourself. You probably need to search for SET NAMES UTF8 and DefineEncoding.