Data Types

You can easily use the data types offered by the Kuika Platform in application development processes. Browse data types now.

DECIMAL and NUMERIC

Getting numbers in specific precision and scale.

DECIMAL and NUMERIC are functionally same.

Syntax:

DECIMAL (precision [ , scale ] )
NUMERIC (precision [ , scale ] )

Example:

SELECT CAST (123 AS DECIMAL (5,2) ) --returns 123.00
SELECT CAST (12345 AS DECIMAL (10,5) ) --returns 12345.12000

FLOAT and REAL

Approximation of numbers in data types.

SELECT CAST (PI() AS FLOAT) ----returns 3.14159265358979
SELECT CAST (PI() AS REAL) ----returns 3.141593

Integers

Data types that use exact numbers, divided between ranges and storage sizes.

MONEY and SMALLMONEY

Data types that represent money and currency

BINARY and VARBINARY

Binary data types that have either fixed or variable lengths.

Syntax:

BINARY [ ( n_bytes ) ]
VARBINARY [ ( n_bytes | max ) ]

n_bytes can differ from 1 to 8000 bytes. max indicates that the maximum storage space is 2^31-1.

Examples:

SELECT CAST (12345 AS BINARY (10) ) --0x000000000000000003039
SELECT CAST (12345 AS VERBINARY (10)) --0x00003039

CHAR and VARCHAR

String data types that have either fixed or variable lengths.

Syntax:

CHAR [ ( n_bytes ) ]

VERCHAR [ ( n_bytes ) ]

Examples:

SELECT CAST ('ABC' AS CHAR (10) ) ---'ABC      '(padded with spaces on the right)
SELECT CAST ('ABC' AS VARCHAR (10) ) ---'ABC' (no padding due to variable caracter)
SELECT CAST ('ABCDEFGHIJKLMNOPRSTUVWYZ'  AS CHAR (10)) ---'ABCDEFGHIJ' (truncated to 10 caracters)

NCHAR and NVARCHAR

UNICODE String data types that have either fixed or variable lengths.

Syntax:

NCHAR ( (n_bytes) ]
NVARCHAR [ ( n_bytes| max) ]

You can use MAX for very long strings longer than 8000 characters.

UNIQUEIDENTIFIER

A 16-byte GUID / UUID.

DECLARE @GUID UNIQUEIDENTIFIER =NEWID ();
SELECT @GUID ---'E28B3BD9-9174-41A9-8508-899A78A33540'
DECLARE  @bad_GUID_string VARCHAR(100) ='E28B3BD9-9174-41A9-8508-899A78A33540_foobarbaz'
SELECT 
    @bad_GUID_string, --'E28B3BD9-9174-41A9-8508-899A78A33540'
    CONVERT (UNIQUEIDENTIFIER, @bad_GUID_string) --'E28B3BD9-9174-41A9-8508-899A78A33540'

Kuika Data Types

• Date; only contains the date data value.

• Date time; contains the time value in addition to the date. DatetimeOffset contains the Timezone.

• Int32; allows keeping integers.

• Double; holds numbers up to 2 fractions.

• Decimal; allows keeping numbers up to 10 fractions.

• FileContent; is used to store files such as PDFs.

• Guid; indicates a singular value, such as an ID number. In the managedDB database, which is associated with a workspace specific to Kuika, an ID of GUID type is assigned to each record.

• Image; is used to store image files.

• Location; is used to hold geographic coordinates and GPS data.

• Signature; keeps the signature in image format.

• String; stores alphanumeric characters.

• AutoIncrement; is an auto-incrementing value type.