Caspio Bridge Data Types

Data types indicate and enforce the type of data that can be stored in a field in a table.  The following data types are supported in Caspio Bridge:

 

 

AutoNumber

AutoNumber is a numeric field that is maintained automatically by Caspio Bridge.  AutoNumbers start with 1 and increment by one for each new record.  This data type is ideal for uniquely identifying each record.

 

Examples: CustomerID, RecordID

Text (255)

 

  and

Text (4000)

A Text field stores any kind of text and special characters.  It can hold up to 255 or 4000 characters.  Use Text (255) where possible for better performance.

 

Text (4000) cannot be set as a unique field. When a field of Text (4000) is converted to Text (255), data is truncated.

 

Examples: Name, Description, Address, Phone

Number

 

Number fields store any type of numeric value, with or without a decimal point.

 

Example: Age, Salary, Price

Date/Time

 

Date/Time fields hold date and/or time values.

 

Examples: SubmissionDate, ModificationDate, Birthday

Yes/No

 

Yes/No fields can have only one of the two values, yes or no. A Yes/No field cannot be set as a unique field.
 

Examples: ActiveCustomer, Published, SeniorCitizen

File

 

File fields are used to store files and images. A file field cannot be set as a unique field.

 

Examples: Portrait, PropertyImage, Resume

 

 

Selecting the correct data type is important and allows you to benefit from Caspio Bridge's data-type-specific features such as data validation and sorting.

 

Choose the Text data type for seemingly numeric fields that are never used as a number in calculations.  Examples include phone numbers and zip codes.