Home / Documentation / FAQ / Support / Download SQL Data Types

### SQL Data Types Index

> 1. SQL Data Types Introduction
> 2. SQL Data Types Supported

1. SQL Data Types Introduction

> Mckoi SQL was designed to support a wide range of data types without the size/scale limitations often seen in other SQL products. SQL data types in Mckoi are internally backed by a few very flexible primitive types. This enables for the support of all the standard SQL types with a high degree of scalability while keeping the core engine design simple.

> This section provides information on the data types supported by Mckoi SQL Database.

2. SQL Data Types Supported

> The following is a list of SQL types that Mckoi SQL supports;

> `BOOLEAN` - A boolean value either true, false or null.

> `CHAR(size)` or `CHARACTER(size)` - A string of fixed length. The maximum size of a `CHAR` string is 1 billion characters.

> `VARCHAR(size)`, `LONGVARCHAR(size)`, `CHARACTER VARYING(size)`, `LONG CHARACTER VARYING(size)`, `TEXT(size)` or `STRING(size)` - A string of variable length. The size constraint of these string types do not have to be given and defaults to the maximum possible size of strings that the database is able to store. The maximum size of these string types is 1 billion characters.

> `CLOB` - A string of variable length without a size constraint. The maximum size of a `CLOB` object is 1 billion characters.

> `TINYINT` - An 8-bit signed integer value. The range of `TINYINT` is -128 to 127.

> `SMALLINT` - A 16-bit signed integer value. The range of `SMALLINT` is -32768 to 32767.

> `INTEGER` or `INT` - A 32-bit signed integer value. The range of `INTEGER` is -2147483648 to 2147483647.

> `BIGINT` - A 64-bit signed integer value. The range of `BIGINT` is -9223372036854775808 to 9223372036854775807.

> `FLOAT` or `DOUBLE` - A 64-bit precision floating point value. These types are analogous to the Java `double` type.

> `REAL`, `NUMERIC` or `DECIMAL` - A higher precision numeric value. These numeric types are represented by `java.math.BigDecimal` and therefore can represent numeric values of any precision and scale.

> `DATE` - A day/month/year value. The `DATE` type does not have any near time bounding issues and is able to represent dates many millennia in the future and the past. The `TIMESTAMP` type is internally represented by `java.util.Date`.

> `TIME` - A time of day value.

> `TIMESTAMP` - A day/month/year and time of day value. The `TIMESTAMP` type does not have any near time bounding issues and is able to represent dates many millennia in the future and the past. The `TIMESTAMP` type is internally represented by `java.util.Date`.

> `BINARY(size)`, `VARBINARY(size)` or `LONGVARBINARY(size)` - A variable sized binary object. The size constraint is optional and defaults to the maximum size. The maximum size of a binary object is 2 billion bytes.

> `BLOB` - A variable sized binary object with no size constraint. The maximum size of a binary object is 2 billion bytes.

> `JAVA_OBJECT` - A Java object. A Java object must implement the `java.io.Serializable` interface and abide by the rules of serializable objects in Java.

Last Updated: Mon Aug 16 00:27:18 PDT 2004 Mckoi SQL Database Copyright © 2000 - 2004 Diehl and Associates, Inc. All rights reserved.