phone number should be a string or some numeric type that have capacity to save phone number?

by

ITU-T recommendation E.164 says you need 3 digits for the country code and up to 15 digits for the directory number within the country dialing plan.

And, many people add some punctuation. For example:

+1.212.555.1212 is a North American number. It could also be rendered
(212) 555-1212 in a North American centric app.

32 characters of text should do the trick worldwide.

DO NOT use a number, or you’ll be sorry. I was: two things.

  • Lost some European business for a company because we assumed all phone numbers were NANP-compliant ten-digit numbers.
  • A spreadsheet export rendered the numbers in scientific notation 2.12555E+09 That’s almost as stupid as SIRI telling me you have call from two bllion, one hundred twenty five million….

Telephone directory numbers are not numeric data types. Take a look at this: Falsehoods Programmers Believe About Telephone Numbers.

More Related Contents:

  1. convert sql query into lambda expression [closed]
  2. How do parameterized queries help against SQL injection?
  3. How to execute an .SQL script file using c#
  4. Parsing SQL code in C# [closed]
  5. Entering keys manually with Entity Framework
  6. Pass table valued parameter using ADO.NET
  7. Getting return value from stored procedure in C#
  8. SQL error: Incorrect syntax near the keyword ‘User’
  9. Why does the Contains() operator degrade Entity Framework’s performance so dramatically?
  10. Query extremely slow in code but fast in SSMS
  11. Could not find an implementation of the query pattern
  12. DateTime format to SQL format using C#
  13. Filter sql based on C# List instead of a filter table
  14. C# guid and SQL uniqueidentifier
  15. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  16. Stop SQL query execution from .net Code
  17. Entity Framework. Delete all rows in table
  18. SQLException : String or binary data would be truncated
  19. Multi threading C# application with SQL Server database calls
  20. C# Version Of SQL LIKE
  21. Use linq to generate direct update without select
  22. NHibernate – Many to Many Query using Junction/Joiner Table
  23. When is it better to write “ad hoc sql” vs stored procedures [duplicate]
  24. Convert SQL to LINQ Query [closed]
  25. Must declare the table variable @table
  26. how to recognize similar words with difference in spelling
  27. Use SQL Server time datatype in C#.NET application?
  28. How to use String property as primary key in Entity Framework
  29. Generating sql code programmatically
  30. Do we have transactions in MS-Access?

Leave a Comment