MySQL Forums
Forum List  »  Connector/ODBC

Source character set not supported by client error on SHOW TABLES command
Posted by: Mor Sagmon
Date: May 23, 2018 03:32AM

I'm connecting to MySQL Server 8.0.11 using Excel VBA using ODBC 5.3 driver.
I can execute most statements and queries without a problem (including DDL statements and LOAD FILE LOCAL).

One statement, SHOW TABLES FROM <schema> LIKE '<table_name>' is causing an error:

Microsoft Visual Basic

Run-time error '-2147467259 (80004005)':

[MySQL][ODBC 5.3(w) Driver][mysqld-8.0.11]Source character set not supported by client

This is persistent with ODBC 5.3.4 through 5.3.11 driver (32 bit).

This (equivalent) statement also produces this error:

SELECT * FROM information_schema.tables WHERE table_schema = 'xxxx' AND table_name = 'xxxx' LIMIT 1;

my.ini has:
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci

The schema and table columns are all created with utf8 correctly.
Running on Windows10 64bit hosting both Excel (Office 2016) and MySQL.

Connection string (ADODB):

Driver={MySQL ODBC 5.3 Unicode Driver};Server=localhost;Port=3306;Database=xxx;Uid=xxx;Pwd=xxx;charset=UTF8;OPTION=16427;

connection user has privileges on all schemas, no limitations, with all global privileges granted, except: CREATE TABLESPACE, CREATE USER, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHUTDOWN, SUPER

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.