#526 MariaDB 10.6.3 stable - Unknown MySQL data type!

[Jony Rh]

Lazarus 2.0.12, FPC 3.2.0, ZeosDBO from Online Package Manager, Win10 64

Using protocol "MariaDB-10" and libmariadb.dll from install dir MariaDB10.6

After try connect with out params and database: Error "Unknown MySQL data type!"

[Jony Rh]

Dont work only with libmariadb.dll included on MariaDB 10.6.3 stable
Version included library MariaDB Connector/C v3.2.3

[marsupilami79]

Hello Jony,

as a workaround you might want to use MariaDB Connector/C Version 3.1.13: https://downloads.mariadb.org/connector-c/3.1.13/
This version seems to work correctly.

It seems that version 3.2.3 uses a different layout for the MYSQL_FIELD structure.

[marsupilami79]

I did some more debugging. This is related to an intentional change in MySQL Connector/C:
https://jira.mariadb.org/browse/CONC-509
https://github.com/mariadb-corporation/mariadb-connector-c/commit/a37b7c3

Zeos thinks that it talks to a very old library because mysql_get_client_version returns 30203 in MariaDB Connector/C version 3.2.3 whereas version 3.1.13 returns 100505.

To solve this, we need some way to distinguish between libmysql and libmariadb.

[marsupilami79]

I fixed this in [r7604] for Zeos 7.2. A new release will happen in some days.

[Jony Rh]

You are gorgeous! Thank you so much!