> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Enum FieldDataType

> Datatype of the field in the database

Datatype of the field in the database

## Syntax

```crmscript theme={null}
FieldDataType
```

## Fields

| Name                    | Description                                                                                                                                                                               |
| ----------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Undefined               | Undefined data type (error)                                                                                                                                                               |
| dbShortId               | Short integer (e.g. System.Int16) id.                                                                                                                                                     |
| dbDateTimeUTC           | DateTime ( e.g. seconds since 01.01.1970) in UTC stored as an integer value in the database.                                                                                              |
| dbDouble                | Double precision real (e.g. System.Double) value.                                                                                                                                         |
| dbInt                   | Integer (e.g. System.Int32) value.                                                                                                                                                        |
| dbIntId                 | Integer (e.g. System.Int32) id.                                                                                                                                                           |
| dbDateTimeLocal         | DateTime ( e.g. seconds since 01.01.1970) in Local time stored as an integer value in the database.                                                                                       |
| dbUShort                | Unsigned short integer (e.g. System.UInt16) value                                                                                                                                         |
| dbShort                 | Short integer (e.g. System.Int16) value                                                                                                                                                   |
| dbNull                  | This is not a value                                                                                                                                                                       |
| dbUInt                  | Unsigned integer (e.g. System.UInt32) id                                                                                                                                                  |
| dbBlob                  | Blob in hte database                                                                                                                                                                      |
| dbStringBlob            | Long string (e.g. System.String) stored as a (text) blob in the database                                                                                                                  |
| dbString                | String (e.g. System.String) preferebly stored as a variable lenght string in the database.  The Length can be up to (e.g. not including) 256 characters long depending upon the datatype. |
| dbExtendedDateTimeLocal | DateTime, stored as a real datetime in the database, with extended range. Local time zone                                                                                                 |
| dbExtendedDateTimeUTC   | DateTime, stored as a real datetime in the database, with extended range. UTC  time                                                                                                       |
| dbTimeLocal             | Time, stored as a datetime in the database, with date value that should be ignored. This time is not timezone converted/sensitive                                                         |
| dbDateLocal             | Date, stored as a datetime in the database, with time value that should be ignored. This time is not timezone converted/sensitive                                                         |
| dbIntIdArr              | Array if int's that represent ID's (foreign keys). Stored encoded as a long string, with each int becoming a word that can be fulltext indexed                                            |


## Related topics

- [Enum ExtraDataFieldType](/en/automation/crmscript/reference/CRMScript.NetServer.ExtraDataFieldType.md)
- [Enum ConfigFieldType](/en/api/plugins/quote-connectors/api/enums/configfieldtype.md)
- [Enum values for FieldMetadataType](/en/database/tables/enums/fieldmetadatatype.md)
- [Enum values for FormFieldRestrictionType](/en/database/tables/enums/formfieldrestrictiontype.md)
- [Enum FieldMetadataType](/en/automation/crmscript/reference/CRMScript.NetServer.FieldMetadataType.md)
- [Enum UDefFieldType](/en/automation/crmscript/reference/CRMScript.NetServer.UDefFieldType.md)