Which is best data type for phone number in MySQL and what should Java type mapping for it be?

by

Strings & VARCHAR.

  • Do not try storing phone numbers as actual numbers. it will ruin the formatting, remove preceding 0s and other undesirable things.

  • You may, if you choose to, restrict user inputs to just numeric values but even in that case, keep your backing persisted data as characters/strings and not numbers.

  • Be aware of the wider world and how their number lengths and formatting differ before you try to implement any sort of length restrictions, validations or masks (eg XXX-XXXX-XX).

  • Non numeric characters can be valid in phone numbers. A prime example being + as a replacement for 00 at the start of an international number.

Edited in from conversation in comments:

  • It is one of the bigger UI mistakes that phone numbers have anything to do with numerics. It is much better to think of and treat them like addresses, it is closer to what they actually are and represent than phone “numbers”.

More Related Contents:

  1. MySQL query to get Records in Result set
  2. How to get UTF-8 working in Java webapps?
  3. MySQL JDBC Driver 5.1.33 – Time Zone Issue
  4. Using “like” wildcard in prepared statement
  5. Android JDBC not working: ClassNotFoundException on driver
  6. How to round a number to n decimal places in Java
  7. MySQL and JDBC with rewriteBatchedStatements=true
  8. How to allow introducing only digits in jTextField?
  9. Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  10. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  11. Unable to get spring boot to automatically create database schema
  12. Hibernate: Automatically creating/updating the db tables based on entity classes
  13. Returning a ResultSet
  14. How to change MySQL timezone in a database connection using Java?
  15. How to configure Tomcat to connect with MySQL
  16. Java JDBC MySQL exception: “Operation not allowed after ResultSet closed”
  17. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  18. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Software caused connection abort: recv failed [duplicate]
  19. how to get list of Databases “Schema” names of MySql using java JDBC
  20. Is there a way to run MySQL in-memory for JUnit test cases?
  21. Is there a way to retrieve the autoincrement ID from a prepared statement
  22. Why can Java not connect to MySQL 5.7 after the latest JDK update and how should it be fixed? (ssl.SSLHandshakeException: No appropriate protocol)
  23. Easiest way to convert a Blob into a byte array
  24. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  25. How to use prepared statement for select query in Java?
  26. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  27. org.hibernate.InstantiationException: No default constructor for entity: : principal.Cliente
  28. How to use Spring Boot with MySQL database and JPA?
  29. java.sql.SQLException: No database selected – why?
  30. Make hibernate backquote all table / column names

Leave a Comment