RE: [PHP-DB] db abstraction: sql design
| From: | Manuel Lemos | Date: | Wed, 20 Jun 2001 19:07:07 +0000 |
| Subject: | RE: [PHP-DB] db abstraction: sql design | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9672@lists.php.net to get a copy of this message | ||
Hello Michael,
On 20-Jun-01 05:16:32, you wrote:
>
since U R using an abstraction-layer, most of Ur problems should be solved.
>U should have no problems if U reduce Ur SQL-statements to SQL92-standard.
Not if you use an abstraction layer that does not do for instance data type
conversion. For instance, not all databases takes dates formatted in the
same way.
AFAIK, PEAR-DB is like Perl-DBI and so it does not support datatype
conversion and many other things important for assuring SQL code
portability.
Metabase and ADO-DB support datatype conversion.
Regards,
Manuel Lemos
Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@acm.org
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--