ODBC SQL type -98 is not yet supported

[zxyliho]

Attempt to get content of BINARY column in table of DB2 11.5 database causes exception:

for row in cur:
pyodbc.ProgrammingError: ('ODBC SQL type -98 is not yet supported. column-index=4 type=-98', 'HY106')

The environment:

• OS NAME="openSUSE Leap" VERSION="15.6"
• Python 3.6.15
• pyodbc 4.0.39
• unixODBC 2.3.12
• DB2 CLI ODBC client 11.5.9.0

[ccsrvs]

I added a manual type like this:

def handle_blob(raw):
    return bytes(raw)  # or process bytearray


def custom_types(conn):
    """
    Register custom ODBC types for handling BLOBs.
    """
    # Register a custom output converter for BLOBs
    # -98 is the SQL type for BLOB in some ODBC drivers
    # Adjust the type code as necessary based on your specific driver
    if not hasattr(conn, "add_output_converter"):
        raise RuntimeError(
            "Connection object does not support add_output_converter method."
        )
    conn.add_output_converter(-98, handle_blob)
    conn.add_output_converter(-99, handle_blob)

[bkline]

#1462 is in the hopper.

Test Environment

Component	Version
OS	Linux 6.8.0-101-generic
Distro	Ubuntu 24.04.4 LTS
Architecture	AMD x86_64
DBMS	DB2 v11.5.8.0
IBM ODBC driver	11.5.0 linux 64
Python	3.12.3
unixODBC	2.3.12-1ubuntu0.24.04