Question

Which data type is used to store phone number in phpmyadmin?

Answer 1

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

java mysql phone-number digit

I am using MySQL with Spring JDBC template for my web application. I need to store phone number with only digits (10). I am little bit confused about data type using data type.

What is preferable data type for it in MySQL?

What should be Java data type in Bean (POJO) classes for that?

How can I validate that datatype with javax validations/constrains for length and also only digit allowed?