[unixODBC-support] SQLINTEGER

Suren A. Chilingaryan csa at dside.dyndns.org
Mon Jun 2 08:03:57 BST 2008


Dear developers,

There is some mess with SQLINTEGER definition. MSDN
(http://msdn.microsoft.com/en-us/library/ms714556.aspx) defines
SQLINTEGER to be 'long int'. The unixODBC defines it just 'int' (in
sqltypes.h). This cause a lot of troubles on 64bit platforms. Most of
applications expect to see the 64bit 'long int' number and got 32-bit
'int' instead.

As one of the examples of problems: the PDO_ODBC driver in PHP 5.2.x
will end up with segmentation fault while accessing NULL columns over
unixODBC.

thanks,
Suren



More information about the unixODBC-support mailing list