16 сент. 2008 г. · We use varchar(15) and certainly index on that field. The reason being is that International standards can support up to 15 digits.

15 сент. 2009 г. · You can compute the phone number's formatting at runtime. One possible approach would be to use scalar functions for this purpose (works in SQL Server).

1 июн. 2011 г. · varchar(50) is good for mobile number data type . because it may sometimes contain country code for example +91 or spaces also.

27 нояб. 2015 г. · Store the phone number as a string not an integer. A phone number may look like a number, but you don't want to do numeric transformations on it.

11 дек. 2019 г. · You need to join the Accounts table to a list of all the phone numbers and their types in the Customer table, which you can create with a UNION ALL query.

8 апр. 2022 г. · I'm trying to write a query that would result in one row per record based on the value in one of the columns, in this case it's a phone number type.

28 янв. 2020 г. · I am new to postgresql so can anyone tell me that is there any specific datatype to store phone numbers in postgresql while creating table in pgadmin or is it ...

16 мар. 2016 г. · You'd better store phone number as varchar2 or char type. In Oracle, you can check the validation of phone number by Regular Expression.

20 нояб. 2020 г. · A standard SQL solution would be: select substring(phone, 1, 3) || ' ' || substring(phone, 5, 8) There may be simpler solutions in other databases.

22 июн. 2014 г. · Try using a VARCHAR(20). This allows you the ability to store international phone numbers properly, should that need arise.