sql-servervalidationdatabase-designdata-modelingphone-number

What's the longest possible worldwide phone number I should consider in SQL varchar(length) for phone


What's the longest possible worldwide phone number I should consider in SQL varchar(length) for phone.

considerations:

Consider that in my particular case now, I don't need cards etc. number begins with country code and ends with the extension, no Fax/Phone etc. comments, nor calling card stuff needed.


Solution

  • Well considering there's no overhead difference between a varchar(30) and a varchar(100) if you're only storing 20 characters in each, err on the side of caution and just make it 50.