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

On Wed, 2002-03-20 at 18:00, Lukas Smith wrote: > > Aha! We're misunderstanding eachother, I'm talking about escaping > > special characters in data before embedding it in the query. As for > > types, yes you're right. Today PEAR's prepare emulation puts > ampersands > > and escapes only string data, so you have control over that by passing > > data with the right PHP types. Ideally we should have some knowledge > of > > the types in the database, but I'm not sure if that is realistic. > > Well metabase can do both. > Metabase has internal datatypes that it maps to RDBMS specific > datatypes. > 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? - Stig