Skip to main content

Phone Number Data Type

This data type is applied to numeric data following common patterns that express telephone numbers and known valid phone numbers in the United States.

  • Parentheses are optional around area code values: (###) ###-####

  • Phone numbers may or may not include the 1 at their beginning.

  • Dashes and spaces are optional between groups of numbers.

    注意

    Spaces within a group of values are not supported and will result in a mismatched data type entry.

Standard Domestic U.S:

###-###-#####
(###)-###-#####
##########
1##########

Standard Domestic U.S. with extensions:

(###)-###-#### x ###

  • The dash in ###-#### is required when extension is present.

  • The extension indicator can be one of the following: x, X, ext, or EXT.

International U.S:

+1(###)-###-####

Not supported:

  • Local U.S. format not supported:

    ###-####

  • International format:

    +##-##-###-#####

  • Internal international format not supported:

    ##-##-##-###-#####

Data Validation

In addition to validation against common phone patterns, values are checked against permitted U.S. phone numbers. For example, an area code value of 123 is invalid, as this area code value does not exist in the U.S. phone system.

本节内容如下: