Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
829
|
| Data Type Name | Raw Type | Length (Range) |
Precision (Range) |
Scale (Range) |
Description |
| NUMERIC DATA TYPES | |||||
| INT1 | NUMERIC | 8-bit values in range –128 to 127 | X | X | |
| INT2 |
NUMERIC | 16-bit values in range –32,768 to 32,767 | X | X | |
| INT4 | NUMERIC | 32-bit values in range –2,147,483,648 to 2,147,483,647 | X | X | |
| INT8 | NUMERIC | 64-bit values in range -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 | X | X | |
| NUMERIC |
NUMERIC | Equivalent to numeric(18, 0). | 18 | 0 | 8 bytes |
| FLOAT4 | NUMERIC | Floating point number with precision 6. | 6 | X | 4 bytes |
| FLOAT8 | NUMERIC | Floating point number with precision 15. | 15 | X | 8 bytes |
| CHARACTER DATA TYPES | |||||
| CHAR | CHARACTER | Fixed length, blank padded to length n. The default value of n is 1. The maximum character string size is 64,000. | X | X | If n is equal to 16 or less — n bytes. If n is greater than 16, disk usage is the same as varchar(n) |
| VARCHAR | CHARACTER | Variable length to a maximum length of n. No blank padding, stored as entered. The maximum character string size is 64,000. | X | X | |
| NCHAR | CHARACTER | Fixed length, blank padded to length n. The maximum length of 16,000 characters. | X | X | variable-length with limit – 1GB maximum length |
| NVARCHAR | CHARACTER | Variable length to a maximum length of n. The maximum length of 16,000 characters. | X | X | |
| LOGICAL DATA TYPES | |||||
| BOOL | BOOLEAN | With value true (t) or false (f). | X | X | 1 byte logical Boolean (true/false) |
| DATE & TIME DATA TYPES | |||||
| DATE | DATE | Ranging from January 1, 0001, to December 31, 9999. | X | X | 4 bytes |
| TIME | TIME | Hours, minutes, and seconds to 6 decimal positions. Ranging from 00:00:00.000000 to 23:59:59.999999. |
X | X | 8 bytes |
| TIMETZ | TIME WITH ZONE |
Hours, minutes, seconds to 6 decimal positions, and time zone offset from GMT. Ranging from 00:00:00.000000+13:00 to 23:59:59.999999-12:59. |
X | X | 12 bytes |
| TIMESTAMP | TIMESTAMP | Has a date part and a time part, with seconds stored to 6 decimal positions. Ranging from January 1, 0001 00:00:00.000000 to December 31, 9999 23:59:59.999999. |
X | X | 8 bytes |
| INTERVAL | TIMESPAN | An interval of time. This is a nonstandard implementation | 12 bytes |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017