My mysql database using 5.0.24 version of connection in the pb10 myodbc version of the original use is 3.51.15, can normal connection, but cannot display Chinese character data, are displayed as "????? ", but in mysql query is normal, I know must set character set in mysql to normal display Chinese characters, but couldn't find in the pb10 and related myodbc3.51.15 set character set method,
Later, I on the mysql website to download the latest version myodbc3.51.17, in this version has a character set, set up a DSN everything is normal, when the connection is successful, but in the generated profile description file, use the DSN is an error, pb pb100 said program. Exe error, to close the program,
Do you have come across this kind of problem, how to solve?
Has been for two days, but can't solve, online and other experts to help, thank you

CodePudding user response:

Mysql install mysql character set, if at the time of installation didn't choose good, the tend to have trouble later.

I suggest you reinstall mysql, pay attention in the installation wizard has a step is to choose the string, you can choose gb2132 or utf-8

Of course you also can try to modify the character set each field in each table, with mysql browser can be modified by hand.

CodePudding user response:

If your database inside data is useful, pay attention to the first database backups.

CodePudding user response:

Pb10 support unicode, you try change the mysql character set to utf-8. After modification, you can use the mysql broswer to see whether or not the data display properly

CodePudding user response:

Thanks brother lzheng2001, actually your offer I am tried, my. The default ini file - char I modified, useless, I generated a new test form, character set and finishing with utf8_unicode_ci, but can only display in the pb10? , now is the latest myodbc generated DSN file cannot be used normally, but there is no room to set character set in the old myodbc, other methods didn't effect, how to do?

CodePudding user response:

Ha ha, finally found the solution, write here, for reference of other people:
At the time of old myodbc3.51.15 Settings, in the "connect" options "TAB under the" initial statement "fill in the set of names' GBK, can display properly mysql database of Chinese (my database character set GBK - Chinese - ci).
Good, also thank you again for lzheng2001 brother's enthusiastic reply!