--- title: "Getting Started - Data Types" slug: "getting-started-data-types" updated: 2026-06-18T15:00:46Z published: 2026-06-18T15:00:46Z canonical: "docs.datajet.app/getting-started-data-types" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.datajet.app/llms.txt > Use this file to discover all available pages before exploring further. # Data Types ## ## Field Attributes and Properties | **Property** | **Property window** | **Possible Values** | **Comments** | | --- | --- | --- | --- | | **FieldType** | DataType | String / Integer / Long(Integer) / Double / Date / DateTime | FieldType determines which operations can be performed on the field. FieldTypes are indicated in the solution explorer via symbols, and are listed in the properties window. | | **FieldSize** | - | Low / Med / High / Continuous | Used in Script Editor by File Importer. See table below for mapping to JSON DataSize parameters. | | **DataSize** | DataSize | Byte / Short / Integer / LongInteger / Double / [Custom] / Variable | A single FieldType can have a range of DataSizes, depending on the amount of data stored for the field. It is possible for the DataSize of a field to change if the underlying data changes (for example, a Short could be changed to an Integer) | | **DataType** | Type | Discrete / Continuous | Some functions and operations are restricted by DataType. Previews and statistics are generally not available for fields with Continuous DataType. DateTime fields are continuous. Primary key fields are often continuous. It is possible for a DataType to change if the dimensions (number of discrete values) for the field changes. Depending on the data, it is sometimes possible to transform a field that has been loaded as CONTINUOUS into a DISCRETE DataType. | ## FieldTypes and Symbols | Symbol | Field Type | | --- | --- | | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/getting-started---data-types-image-qb5f8hfg.png) | String | | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/getting-started---data-types-image-4ihs8a47.png) | Integer | | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/getting-started---data-types-image-tri6uqqs.png) | LongInteger / Long | | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/getting-started---data-types-image-depcaobe.png) | Double | | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/getting-started---data-types-image-5o70wje3.png) | Date | | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/getting-started---data-types-image-lfu4vvsv.png) | DateTime | | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/getting-started---data-types-image-p4xzidwn.png) | Field is used in a link/join | | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/getting-started---data-types-image-nq2oimay.png) | Key Field | | ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/getting-started---data-types-image-o5npnvtd.png) | DataSet | ## DataType Limits ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1663945434036.png) | **Field Type** | **Data Load JSON** | | | **Limits** | | | --- | --- | --- | --- | --- | --- | | **type** | **size** | **DataType** | **FieldType** | **DataSize** | **Min** | **Unique Values** | **Note** | | String | Low | DISCRETE | STRING | BYTE | | 250 | String field with up to 250 unique values | | String | Med | DISCRETE | STRING | SHORT | | 65530 | String field with up to 65,530 unique values | | String | High | DISCRETE | STRING | INTEGER | | 1,000,000 | String field with up to 1,000,000 unique values | | String | Continuous | CONTINUOUS | STRING | [Length] | | | String field with large unknown number of unique values | | String | Variable | CONTINUOUS | STRING | [Variable] | | | String field with any number of unique values | | Integer | Low | DISCRETE | INTEGER | BYTE | | 250 | Integer field with up to 250 unique values | | Integer | Med | DISCRETE | INTEGER | SHORT | | 65530 | Integer field with up to 65,530 unique values | | Integer | High | DISCRETE | INTEGER | INTEGER | | 1000000 | Integer field with up to 1,000,000 unique values | | Integer | Continuous | CONTINUOUS | INTEGER | INTEGER | | | Integer field with large unknown number of unique values | | Long | Low | DISCRETE | LONGINTEGER | BYTE | | 250 | Big Integer field with up to 250 unique values (Use if number > 2 billion or < -2 Billion) | | Long | Med | DISCRETE | LONGINTEGER | SHORT | | 65530 | Big Integer field with up to 65,530 unique values | | Long | High | DISCRETE | LONGINTEGER | INTEGER | | 100000 | Big Integer field with up to 1,000,000 unique values | | Long | Continuous | CONTINUOUS | LONGINTEGER | LONGINTEGER | | | Big Integer field with up large unknown number of unique values | | Double | Med | DISCRETE | DOUBLE | SHORT | | 655530 | Floating point field with up to 65,530 unique values (Non-integer numerics) | | Double | High | DISCRETE | DOUBLE | INTEGER | | 1000000 | Floating point field with up to 1,000,000 unique values | | Double | Continuous | CONTINUOUS | DOUBLE | DOUBLE | | | Floating point field with large unknown number of unique values | | Date | | DISCRETE | DATE | SHORT | | | Date Field | | DateTime | | CONTINUOUS | DATETIME | | | | Date Time Field | Note: Not much overhead in using a long rather than an integer unless dealing with continuous fields. ### Supported Date Field Formats - YYYY-MM-DD - YYYYMMDD - MM-DD-YYYY - MMDDYYYY - DD-MM-YYYY - DDMMYYYY - M-D-Y Display FormatWithin the system, dates are always displayed in the format YYYY-MM-DD ## Supported Date Time Formats - YYYY-MM-DD HH:MM:SS - DD-MM-YYYY HH:MM:SS - YYYY-DD-MM HH:MM - DD-MM-YYYY HH:MM - DDMMYYYY HH:MM:SS - MM-DD-YYYY HH:MM:SS - YYYYMMDDHHMMSS - DD-MM-YYYY HH:MM:SS AM - MM-DD-YYYY HH:MM:SS AM - M/D/Y HH:MM:SS - D/M/Y HH:MM:SS Display FormatWithin the system, date-time fields are displayed in the format YYYY-MM-DD HH:MM:SS