4 ms·
15 is the ITU max BTW - something to be aware of for HN contributors when setting up DB Schemas that stope phone numbers.
by C1sc0cat 7y ago
15 is the ITU max BTW - something to be aware of for HN contributors when setting up DB Schemas that stope phone numbers.
- raverbashing 7y agoSorry for being cynical, but I've had my share of "things that would never happen because of standards/regulations/common sense" happen when you're storing data in DBs Phones have at most 15 digits? I'm putting 20 or 25 just in case.
- DaiPlusPlus 7y agoA system I worked on used the RDBMS’ default of 50 characters in a varchar column and the validation regex allowed uppercase alphanumeric input (for “1-800-CONTACTS”-style numbers) and also allowed spaces in addition to dashes. But the system didn’t allow users to label numbers in a separate field - so the users put the labels at the end of each number, e.g. “425-123-7890 JOHN SMITH, HOME”. The system used this value for generating tel: links in webpages - which meant the links wouldn’t work anymore - but users preferred keeping these custom labels to having Skype-integrated or iOS tappable links anyway. /csb
- kalleboo 7y agoSometimes people want to add internal extension numbers to phone numbers, so having breathing room to enter those makes sense too
- C1sc0cat 7y agoI think those exist within the numbering plan, and sound extensions be a separate field in the db any how.
- throw0101a 7y ago> Phones have at most 15 digits? I'm putting 20 or 25 just in case. That's fine, but if we have to go beyond 15 digits, it will probably be an upgrade as big as going to IPv6 128-bit addresses given that the ITU has specified fifteen for a while now: * https://en.wikipedia.org/wiki/E.164 https://en.wikipedia.org/wiki/E.164