Data validation at the db level
| From: | Chris W. Parker | Date: | Thu, 07 Sep 2006 22:56:10 +0000 |
| Subject: | Data validation at the db level | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-241465@lists.php.net to get a copy of this message | ||
Hey everyone,
Is there any work being done in the database world for data validation
at the db level?
It would be cool to just define a field as being an email address (of
length nn) instead of saying a TEXT field (of length nn) and validating
it in the application layer. Same goes for other things as well.
Sure, it's not really possible to account for all different types of
data, but the basics would be nice. (email, numbers only, letters only,
alphanumeric only, [a-z0-9#-] only, etc.)
Chris.