NYCPHP Meetup

NYPHP.org

[nycphp-talk] storing phone numbers in MySQL

Faber Fedor faber at linuxnj.com
Wed Mar 10 17:43:10 EST 2004


On Wed, Mar 10, 2004 at 05:37:52PM -0500, David Mintz wrote:
> 
> Jeez I'm awful sorry to disturb you again but... you do store them as
> string types, right? If they were actually numeric in the data layer (as
> opposed to the form input) and there were a leading zero somewhere it
> sounds like it could get ugly.

I've always used the argument that two pieces of data are numeric if you
can add (subtract, etc.) them together and get another number.  Since
you can't do that with phone numbers (or social security number, etc.),
they are not numbers.

> PS I am loving that QuickForm, oh yesssssss.

I've got it bookmarked and am waiting for a quiet weekend to come
along...

-- 
 
Regards,
 
Faber                     

Linux New Jersey: Open Source Solutions for New Jersey
http://www.linuxnj.com






More information about the talk mailing list