Out of range value for column error

Please confirm the data type of column 'phonenumber' in MySQL, you may be providing a value larger than the data type can handle.  

Hi Chris,

I iam using "Text " Data type.But I have tried integer also .if I used integer it's taking only single value should be 1234567890 apart from this value it's not taking any new digits like phone number start with 987...... Or 877666....  Getting error

Hi Sasikala,

Could you please provide a screenshot for the cdt - NewAccountDetails?

Typically you'd simply want to treat phone numbers as Text, both in Appian and in the Database. This is because you usually want to handle international calls - so the + symbol to indicate a country code; and/or area codes, usually wrapped in () ; and also spaces to make it easier for end-users to read (people can hold numbers better in their heads if they're 'chunked') e.g. +44 (0) 1508 571234

If you want to validate a phone number that is being captured then there are RegEx expressions available to ensure they conform to an expected pattern.

So, in short: use a Text Field in your User Interface; a Text attribute in the CDT; and a Text column in the Database, all of the same length.

What does your database table look like? Do you also have a text field in the column in your database? Also what is the length of the column in the database (even if you use text)?

What does your database table look like? Do you also have a text field in the column in your database? Also what is the length of the column in the database (even if you use text)?