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 <norb...@linuxnetworks.de> 
> 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
> libopendbx-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX

------------------------------------------------------------------------------
_______________________________________________
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX

Reply via email to