Re: [opendbx] MySQL unsupported data types
Brought to you by:
nose
From: Brad <bss...@gm...> - 2014-10-31 14:02:49
|
It is frustrating that there really is no such thing as ANSI standard SQL from virtually any of the database vendors. I understand your desire to provide some semblance of ANSI standard and I applaud you for your efforts. Would you be open to creating a new more inclusive "odbx_column_type_nonansi" function that does provide full support for each type? This way each user could choose to use either ANSI support or non-ANSI support for types. Brad Selfridge 913-269-2385 > On Oct 31, 2014, at 2:07 AM, Norbert Sendetzky <no...@li...> wrote: > > Hi Brad > >> I've researched the OpenDBX source files and have found that not >> all column types are being returned. It seems most databases >> supported have this anomaly. I'm curious as to why? >> >> It doesn't make sense to me why each database interface program >> wouldn't support all types for that database. I must not >> understand something. Please educate me. > > OpenDBX supports the ANSI data types which have a defined format and > semantics. Database vendors invented much more data types for special > cases which doesn't fit into the ANSI scheme. These special data types > are summarized as TYPE_UNKNOWN in OpenDBX which only means that they > doesn't fit into the existing ANSI types and their data is returned in > its native format without any conversion. So TYPE_UNKNOWN is only > another data type for all remaining database specific types. > > > Norbert > > > ------------------------------------------------------------------------------ > _______________________________________________ > libopendbx-devel mailing list > lib...@li... > https://lists.sourceforge.net/lists/listinfo/libopendbx-devel > http://www.linuxnetworks.de/doc/index.php/OpenDBX |