MySQL ODBC Access Coding problem notes

In old programming software such as VB6, the MySQL database is accessed through ODBC, regardless of the UTF8 or GBK of the database used on the server, the test discovery client must be set to GBK to display the kanji correctly:

If the data field may contain other languages, the following settings are required:

1, the server-side data table needs to use UFT8 encoding, in order to accommodate other language text:

2. The client is driven by the Unicode version of MySQL ODBC, the ANSI version can only display Chinese simple and traditional, cannot display other language text:

The test results are as follows:

The figure is a adodc control with VB6 and a DataGrid control.

MySQL ODBC Access Coding problem notes