When AUTO_IS_NULL is not set the driver changes between zeros and nulls, I think you need to configure the ODBC

"When AUTO_IS_NULL is set, the driver does not change the default value of sql_auto_is_null, leaving it at 1, so you get the MySQL default, not the SQL standard behavior.

When AUTO_IS_NULL is not set, the driver changes the default value of SQL_AUTO_IS_NULL to 0 after connecting, so you get the SQL standard, not the MySQL default behavior.

Thus, omitting the flag disables the compatibility option and forces SQL standard behavior.

See IS NULL. Added in 3.51.13."

Youre seeing zero and thinking its a 0 but its really a default value

https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html