|
Set the field to VARCHAR(25)
That should handle all international phone numbers easily. VARCHAR(16) *should* handle things but people are weird when they type phone numbers.
DO NOT make it a TEXT field if you want it to be easily indexed. I see morons constantly that use TEXT as the default field type in mySQL. Not only is it cumbersome to index without performance hits, it takes up horrendous amounts of space in the database as it reserves 64K per row.
A phone number should never be set to TEXT in mySQL.
|