what should be the data type set for phone number in sql so that it matches the data type phone in outsystems
Hi Shalini,
You can define phone number type in Outsystem.
Regards,
Amreen
Hi,
It will be the same data type as set for the OutSystems Text Data type.
https://success.outsystems.com/documentation/11/reference/outsystems_language/data/data_types/available_data_types/
See this document with mapping of OutSystems data types to Database server database types:
https://success.outsystems.com/documentation/11/reference/outsystems_language/extensibility_and_integration/mapping_external_db_data_types_to_outsystems_data_types/
The main advantage in OutSystems to use a specific data type Phone Number is that the keyboard that is shown to the user is different.
See also https://developer.mozilla.org/en-US/docs/Web/HTML/Element/input/tel
The Forge contains components for phone number validation: https://www.outsystems.com/forge/component-overview/10647/international-telephone-input-reactive
Daniel