Re: [ODBC 5.1 Driver]Can't initialize character set utf8mb4 (path:/usr/local/mysql/share/charsets/) {HY000,NativeErr = 2019}

[Yash Dave]

Thank you Peter, Edwin,

I will try and use higher version (I will need to compile them since they are not available for AIX 5.3).

And I think I was dealing with two issues:

(1) I had missed installing the MySQL client software on the AIX server that has Oracle DB (there was no prior MySQL s/w installed at all on that AIX server, the MySQL DB instance was only on the second RHEL 7.7 server).

I downloaded mysql-5.1.66-aix5.3-powerpc-64bit.tar.gz and extracted it in /usr/local, created symbolic link "mysql" to /usr/local/mysql-5.1.66-aix5.3-powerpc-64bit/ to make the /usr/local/mysql/share/charsets/ available.
It still only brought "utf8" as both you had mentioned (it didn't know about "utf8mb4")

After above, if I had a DB created with "utf8" character set, a table with character data, I was able to query that column from Oracle Database link.


(2) Only my db instance v5.7.33 default character set was "utf8" character set, but the application databases inside were created with "utf8mb4".

And as both of you pointed out, connector odbc v5.1.8 only knew about "utf8".

I am going try and recompile the Connector/ODBC v8.x or some lower v5.3.x version source (after I get the c compiler working on this AIX server).

Thank you both for your help. Appreciate it.


Yash

(We can close this thread).