Michael Zelina wrote:
> This is an interesting idea... I thought about doing this,
> but the variety of data types prohibited me from doing so.
> Initially, I was going to make everything VARCHAR(80)... but
> that seemed to be horrible for data storage purposes and would
> prevent me from being able to use SQL functions for numeric
> items without converting the items first.
The data conversions are automatic in the server.
"abcd" + 0 is 0
"1234" + 1 is 1235
Use the data type field to select the correct input validation routine, but
store everything as a varchar. You can then make up your own datatypes,
like "state" or "city", or "phone".
Perl is typeless anyway. If you do math it is a number.
If you concat two variables, then they are strings.
This works very well.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
