Bug #119486 Connector/C ANSI fails to select multibyte table names

• Submitted: 1 Dec 14:33
• Reporter: Sruli Ganor
• Status: Open
• Category: Connector / C
• Severity: S1 (Critical)
• Version: 9.5 ANSI
• OS: Windows
• CPU Architecture: Any

[1 Dec 14:33] Sruli Ganor

Description:
Hi, 

When using Connector/C ANSI 9.5, SELECT queries fail to work with schemas and tables that have multibyte names.

E.g., we have a schema called 六 on MySQL 8.4:
(六 is encoded in UTF8 as x'E585AD')

To find the tables in this schema, our C application prepares a statement like this, and runs it with SQLExecute:

select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='六';

With the Unicode connector, the query returns all the schema's tables.
With the ANSI connector, it returns 0 tables (on the same MySQL server)

Notes
1. The connection string includes "charset=utf8mb4"
2. Please don't advise to use the Unicode connector. Due to changes you have made in version 9 that are incompatible with version 8, the Unicode version became unsuitable for us).

Please advise. This is critical.
Thanks

How to repeat:
Create a scema called 六 or any other multibyte name.
Creatde table in this schema.

From a C/C++ program, prepare and execute the above statemnt
and run it with the connector/C 9.5 ANSI version.