07-31-2023, 02:21 AM
What's the longest possible worldwide phone number I should consider in SQL `varchar(length)` for phone.
considerations:
- \+ for country code
- \() for area code
- x + 6 numbers for Extension extension (so make it 8 {space})
- spaces between groups (i.e. in American phones +x xxx xxx xxxx = 3 spaces)
- here is where I need your help, I want it to be worldwide
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.
considerations:
- \+ for country code
- \() for area code
- x + 6 numbers for Extension extension (so make it 8 {space})
- spaces between groups (i.e. in American phones +x xxx xxx xxxx = 3 spaces)
- here is where I need your help, I want it to be worldwide
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.