Can bigint in SQL be mapped in appian?

Question

Hi, 
 
 I am using bigint for storing codes, account numbers(as they can go upto 15-20 digits) in SQL. I need to use them in Appian. Is there a way to map tis data?

Shanmathi Ponnusamy · Answer

HI riyak9492 , 
 You can use Text to map those bigint values Since in appian we have only few primitive data types. 
 Refer this link docs.appian.com/.../Appian_Data_Types.html

Soma · Answer

Appian does not support bigint. Numbers longer than int are converted to &infin;. 
 You can use varchar in sql to store the codes and map it to text in appian.

Partha · Answer

You can use the text variable in appian to store big int type . Use Varchar in SQL, then map that appian text variable.