[libdbi-devel] libdbi doesn't handle unsigned int and unsigned long long types (Patch attached)

[Markus H. <mar...@mh...>]

Hi,

Frederic Gonieaux writes:
 > Hi,
 > 
 > Most of the dbi drivers don't handle correctly the column types
 > unsigned int and unsigned long long.
 > 

SQL does not support unsigned integers. Unsigned integers are a MySQL
extension of the standard and as such not portable. At least SQLite,
PostgreSQL, and Firebird do not use unsigned integers (maybe Oracle
does, I don't know).

The current behaviour emulates unsigned integers in a portable way
which works across all supported database engines. It is questionable
whether your mysql driver patch would offer that much benefit as the
extended range of unsigned integers would be limited to users of that
driver.
 
I'm open for discussions whether this is a useful feature or not.

regards,
Markus

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de