DeveelDB  20151217
complete SQL database system, primarly developed for .NET/Mono frameworks
Classes | Enumerations
Deveel.Data.Types Namespace Reference

Classes

class  ArrayType
 
class  BinaryType
 
class  BooleanType
 
class  BooleanTypeTest
 
class  ColumnType
 
class  ContextExtensions
 
class  DataTypeMeta
 
class  DataTypeParseTests
 
class  DateType
 
class  IntervalType
 
interface  ISizeableType
 
interface  ITypeResolver
 
class  NullType
 A data type that represents the NULL value of a given SQL data type. More...
 
class  NumericType
 
class  PrimitiveTypes
 Provides some helper functions for resolving and creating SqlType instances that are primitive to the system. More...
 
class  QueryExtensions
 
class  QueryType
 
class  RowType
 
class  SqlType
 Defines the properties of a specific SQL Type and handles the values compatible. More...
 
class  StringType
 
class  StringTypeTests
 
class  SystemContextExtensions
 
class  TabularType
 
class  TypeManager
 
class  TypeResolveContext
 
class  TypeResolver
 
class  TypeSerializer
 
class  UserType
 
class  UserTypeInfo
 
class  UserTypeMember
 

Enumerations

enum  SqlTypeCode {
  SqlTypeCode.Unknown = 0, SqlTypeCode.Null = 1, SqlTypeCode.Boolean = 9, SqlTypeCode.Bit = 10,
  SqlTypeCode.TinyInt = 11, SqlTypeCode.SmallInt = 12, SqlTypeCode.Integer = 13, SqlTypeCode.BigInt = 14,
  SqlTypeCode.Float = 15, SqlTypeCode.Real = 16, SqlTypeCode.Double = 17, SqlTypeCode.Numeric = 18,
  SqlTypeCode.Decimal = 19, SqlTypeCode.Char = 20, SqlTypeCode.VarChar = 21, SqlTypeCode.LongVarChar = 22,
  SqlTypeCode.Clob = 23, SqlTypeCode.String = 24, SqlTypeCode.Date = 30, SqlTypeCode.Time = 31,
  SqlTypeCode.TimeStamp = 32, SqlTypeCode.DateTime = 35, SqlTypeCode.YearToMonth = 40, SqlTypeCode.DayToSecond = 41,
  SqlTypeCode.Binary = 50, SqlTypeCode.VarBinary = 51, SqlTypeCode.LongVarBinary = 52, SqlTypeCode.Blob = 53,
  SqlTypeCode.Object = 70, SqlTypeCode.Type = 75, SqlTypeCode.Array = 80, SqlTypeCode.QueryPlan = 100,
  SqlTypeCode.RowType = 111, SqlTypeCode.ColumnType = 112
}
 Enumerates the codes of all SQL types handled by the system. More...
 

Enumeration Type Documentation

Enumerates the codes of all SQL types handled by the system.

Enumerator
Unknown 

summary> An unknown SQL type (either not supported by the system. /summary> summary> The NULL object type. /summary>

Null 

summary> A boolean type that can store either true or false values (0 or 1). /summary>

Boolean 
Bit 

A single byte that can have only 1 and 0 as values.

TinyInt 

An integer value that can span from 0 to 255.

SmallInt 

An integer number of 2 bytes.

summary> A 4-bytes long integer type. /summary>

Integer 
BigInt 

A 8-bytes long integer type.

summary> A 4-bytes numeric value with a floating point. /summary>

Float 

summary> /summary>

Real 

summary> A 8-bytes numeric value with a floating point. /summary>

Double 
Numeric 

A generic numeric type. This is the main type used by the system to represent numbers.

summary> A 128-bit decimal number with floating point. /summary>

Decimal 

summary> Defines a character type with fixed size given /summary>

Char 

summary> The character type with a variable size, within a maximum size given. /summary>

VarChar 

summary> /summary>

LongVarChar 

summary> A type that can store either large amount of ASCII or UNICODE character data. /summary>

Clob 
String 

A long string in the system.

summary> /summary>

Date 

summary> /summary>

Time 

summary> /summary>

TimeStamp 
DateTime 
YearToMonth 
DayToSecond 

summary> /summary>

Binary 

summary> /summary>

VarBinary 

summary> /summary>

LongVarBinary 

summary> A type that can store large amount of binary data. /summary>

Blob 

summary> A user-defined generic object type. /summary>

Object 
Type 

summary> /summary>

Array 

summary> /summary>

QueryPlan 
RowType 
ColumnType 

Definition at line 23 of file SqlTypeCode.cs.

23  {
27  Unknown = 0,
28 
32  Null = 1,
33 
38  Boolean = 9,
39 
44  Bit = 10,
45 
49  TinyInt = 11,
50 
54  SmallInt = 12,
55 
59  Integer = 13,
60 
64  BigInt = 14,
65 
69  Float = 15,
70 
73  Real = 16,
74 
78  Double = 17,
79 
84  Numeric = 18,
85 
89  Decimal = 19,
90 
94  Char = 20,
95 
100  VarChar = 21,
101 
104  LongVarChar = 22,
105 
110  Clob = 23,
111 
115  String = 24,
116 
119  Date = 30,
120 
123  Time = 31,
124 
127  TimeStamp = 32,
128 
129  DateTime = 35,
130 
131  YearToMonth = 40,
132 
133  DayToSecond = 41,
134 
137  Binary = 50,
138 
141  VarBinary = 51,
142 
145  LongVarBinary = 52,
146 
150  Blob = 53,
151 
155  Object = 70,
156 
157  Type = 75,
158 
161  Array = 80,
162 
165  QueryPlan = 100,
166 
167  RowType = 111,
168  ColumnType = 112,
169  }
A long string in the system.
A 8-bytes long integer type.
An integer value that can span from 0 to 255.
A generic numeric type. This is the main type used by the system to represent numbers.
An integer number of 2 bytes.
A user-defined TYPE that holds complex objects in a database column.
A single byte that can have only 1 and 0 as values.
An unknown error that was not handled.