r3 - 14 Sep 2006 - 16:04:53 - MorgenSagenYou are here: OSAF > Projects Web > DevelopmentHome > ServicesWorkingGroup > SharingProject > ExternalInformationModel > ExternalInformationModelDataTypes
Primitive Types:
-- MorgenSagen - 12 Sep 2006
- Bytes and Text with variable length -- Length is defined in record type, limited to 1024 bytes
- Lob with encoding and mime-type -- expressed as fields
- Integer, 32-bit signed
- DateTime?, precision in seconds, includes offset from GMT, optional timezone
| Chandler repository | Cosmo | MySQL |
|---|---|---|
| Boolean | . | BOOLEAN, synonym for TINYINT(1); a value of zero is considered false. non-zero values are considered true |
| Symbol (allows alphanumeric and underscore) | . | VARCHAR |
| Importable (Symbol plus dot ".") | . | . |
| Bytes | BinaryAttribute? (length 102400000) | VARCHAR |
| Text (Unicode) | StringAttribute? (length 1024) | VARCHAR |
| Integer | . | INT signed range is -2147483648 to 2147483647. unsigned range is 0 to 4294967295 |
| Long | IntegerAttribute? | BIGINT signed range is -9223372036854775808 to 9223372036854775807. unsigned range is 0 to 18446744073709551615 |
| Float | . | FLOAT single-precision number, approx 7 decimal places |
| Anything | . | . |
| Date | . | DATE 'YYYY-MM-DD' |
| Time | . | TIME 'HH:MM:SS' |
| DateTime? | DateAttribute? | DATETIME 'YYYY-MM-DD HH:MM:SS' |
| DateTimeTZ? | . | . |
| TimeDelta? | . | . |
| TimeZone? | . | . |
| Lob | . | LONGBLOB max len = 4GB |
| URL | . | . |
| UUID | . | . |
| Path | . | . |
| SingleRef? | . | . |
| Dictionary | DictionaryAttribute? (string keys and values) | . |
| Tuple | . | . |
| List | . | . |
| Set | MultiValueStringAttribute? | . |
| Class | . | . |
| Complex | . | . |
Except where otherwise noted, this site and its content are licensed by OSAF under an Creative Commons License, Attribution Only 3.0.
See list of page contributors for attributions.
See list of page contributors for attributions.