Re: [opendbx] MySQL unsupported data types

[Norbert S. <no...@li...>]

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