Hi!

The driver always returns default types for parameters as MariaDB server doesn't not provide metadata for them, and the client has no means to know real parameter types.

Best regards,
Lawrin
From: Volker Wysk via discuss <discuss@lists.mariadb.org>
Sent: Tuesday, May 13, 2025 10:19 AM
To: MariaDB Discuss <discuss@lists.mariadb.org>
Subject: [MariaDB discuss] ODBC driver and SQLDescribeParam()
 
Hi!

I'm working on a high-level database access library, using UnixODBC, MariaDB
and the MariaDB-ODBC-driver. I's for the Mercury programming language.

The MariaDB ODBC 3.1.4 Driver doesn't work when using SQLDescribeParam().
This ODBC function is used to query metadata for the parameters of a
prepared SQL statement (one which includes question marks). Such as the type
of the parameter. The driver returns SQL_VARCHAR for all parameters,
regardless of the actual type of the parameter.

I've installed and tried the newest MariaDB ODBC 3.2.5 Driver, and there's
no difference. It also reports SQL_VARCHAR for all parameters. But I'm not
100% sure I've installed the newer driver correctly.

What is the state of affairs about MariaDB and ODBC parameter metadata?

Thanks,
Volker
_______________________________________________
discuss mailing list -- discuss@lists.mariadb.org
To unsubscribe send an email to discuss-leave@lists.mariadb.org