Re: moving forward: thanks for feedback
| From: | Lukas Kahwe Smith | Date: | Thu, 28 Sep 2006 23:09:20 +0000 |
| Subject: | Re: moving forward: thanks for feedback | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-44160@lists.php.net to get a copy of this message | ||
Greg Beaver wrote:
One concern I have is that all mysql-specific sets are converted into simple text fields. If there is a way to tell MDB2_Schema to use a set type when installing to a mysql database, that would be very good to know. Otherwise, I'll go through the code and make sure that we are validating input properly in places where it may have relied upon the database constraints to catch errors.SET/ENUM are currently not supported in MDB2_Schema. They could be supported for MySQL via custom datatypes. For ENUMs it would be nice to one day support CHECK constraints. SET is sort of un-relational. Then again array support is now part of the standard. Anyways for now the only solution would be to move the necessary logic to the PHP code. regards, Lukas