Re: [binarycloud-dev] RE: [PEAR-DEV] Re: [binarycloud-dev] FW: lets talk "metapear"-politics aside:-)

>> Well metabase can do both. >> Metabase has internal datatypes that it maps to RDBMS specific >> datatypes. Yes. God I love that. :) >> These datatypes are used for prepared queries and can also be used for >> normal queries. Metabase is also aware of the escape characters for each >> RDBMS. > > Does Metabase have this information because of the XML table definition > files, or does it retrieve it from the database? Metabase allows a set of types: integer, text, boolean, date, timestamp, time, float, decimal, clob, blob those you specify in the XML. but metabase knows for each RDBMS: -if that type is supported -how it is supported so no matter what DMBS you use, you get back the same thing. that is of central importance and one of the major reasons binarycloud uses metabase. -alex