RE: [PEAR] Datatype abstraction?
| From: | Lukas Smith | Date: | Mon, 21 Apr 2003 11:30:34 +0000 |
| Subject: | RE: [PEAR] Datatype abstraction? | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-4977@lists.php.net to get a copy of this message | ||
> From: Antti Heinonen [mailto:aahein@utu.fi]
> Sent: Monday, April 21, 2003 1:12 PM
> I've been studying PEAR DB for couple of weeks now and I started to
wonder
> datatypes. Is there any abstract datatype definitions or instructions
how
> to handle datatypes between different database platforms?
> For Example...
> If my script includes create-statement "Create table test( Name
> varchar2(50))" it propably does not work in MySQL, 'cause of varchar2
> datatype. What is the proper way to make this work?
PEAR DB has support for 3 types:
1) quoted
2) unchanged
3) LOB
a more complete approach to datatype abstraction is possible with MDB:
http://pear.php.net/package-info.php?package=MDB
regards,
Lukas