Bug #86285 DSN name in UTF-8 is not supported
Submitted: 11 May 2017 16:21 Modified: 12 May 2017 10:02
Reporter: Yi Chang Email Updates:
Status: Verified Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.3 Unicode driver OS:CentOS (7.x)
Assigned to: CPU Architecture:Any

[11 May 2017 16:21] Yi Chang 
Description:
If the odbc DSN name has UTF-8 character in it, the sql connection will fail.

How to repeat:
Add a UTF-8 character into the DSN name, for example in odbc.ini:
[進mysql1]
Driver = MySQL ODBC 5.3 Unicode Driver 
Database = xxxxx
Server = xx.xx.xx.xxx
Port = 3306

[mysql2]
Driver = MySQL ODBC 5.3 Unicode Driver
Database = xxxxx
Server = xx.xx.xx.xxx
Port = 3306

"iusql mysql2 username passwd" will work. But "iusql '進mysql1' username password" will fail with Error: Could not SQLDriverConnect

Please check the forum discussion for detail. https://forums.mysql.com/read.php?37,656878,657345#msg-657345
[12 May 2017 10:02] Chiranjeevi Battula 
Hello Yi Chang,

Thank you for the bug report.

Thanks,
Chiranjeevi.
[19 Jan 2023 11:33] Bogdan Degtyariov 
Posted by developer:
 
Re-verified against ODBC Driver 8.0.32.
The problem is still present. The DSN is picked up, but the options in it are ignored. Instead of connecting with USER specified inside the DSN the driver is trying to connect with the OS user account.