NYCPHP Meetup

[David Mintz]

This isn't the sexiest and most thrilling of topics, but I'm just curious.

When you guys store 10 digit phone numbers in a MySQL database, generally
speaking, how do you do it -- data type, width, format? Do you strip all
the non-digits so as to make them format-agnostic, and reformat them at
fetch time? Or do you enforce a format like (xxx) xxx-xxxx so they'll all
be consistent? Do you keep a separate column for an optional extension, or
allow enough width for "(xxx) xxx-xxxx Ext.xxxx" ?

Hey you in the back of the room, stop snoring.

Thanks,


---
David Mintz
http://davidmintz.org/

        "Anybody else got a problem with Webistics?" -- Sopranos 24:17