Enum EDataType

Namespace

gudusoft.gsqlparser

Assembly

gudusoft.gsqlparser.dll

@since v1.4.3.0

public enum EDataType

Fields

array_t = 161

bfile_t = 2

bigint_t = 3

ansi2003: bigint postgresql

bigserial_t = 96

binary_double_t = 6

binary_float_t = 5

binary_integer_t = 7

plsql binary_integer

binary_large_object_t = 8

binary large object Databases: DB2, teradata

binary_t = 4

ansi2003: blob

bit_t = 9

bit_varying_t = 10

blob_t = 11

bool_t = 12

bool, boolean, ansi2003: boolean

boolean_t = 143

box_t = 13

byte_t = 14

teradata: byte

bytea_t = 15

byteint_t = 16

teradata byteint

char_for_bit_data_t = 19

char_large_object_t = 20

teradata: character large object

char_t = 18

character_t = 17

char, character, ansi2003: character

cidr_t = 21

circle_t = 22

clob_t = 23

collection_data_types_collection_t = 128

collection_data_types_list_t = 131

collection_data_types_multiset_t = 130

collection_data_types_set_t = 129

cursor_t = 24

datalink_t = 25

date_t = 26

datetime2_t = 29

datetime_t = 27

ansi2003: timestamp

datetimeoffset_t = 28

dbclob_t = 30

ansi2003: nclob Databases: DB2

dec_t = 32

decimal_t = 31

dec,decimal, ansi2003: decimal

double_precision_t = 142

double_t = 33

double, double precision, ansi2003: float

enum_t = 34

float4_t = 36

float8_t = 37

float_t = 35

generic_t = 1

user defined datetype

geography_t = 39

geometry_t = 40

graphic_t = 38

ansi2003 blob

hierarchyid_t = 41

idssecuritylabel_t = 125

image_t = 42

inet_t = 43

int2_t = 46

int4_t = 47

int_t = 45

integer_t = 44

int, integer, ansi2003: integer

interval_day_t = 49

teradata: interval day

interval_day_to_hour_t = 50

teradata: interval day to hour

interval_day_to_minute_t = 51

teradata: interval day to minute

interval_day_to_second_t = 52

interval_hour_t = 53

teradata: interval hour

interval_hour_to_minute_t = 54

teradata: interval hour to minute

interval_hour_to_second_t = 55

teradata: interval hour to second

interval_minute_t = 56

teradata: interval minute

interval_minute_to_second_t = 57

teradata: interval minute to second

interval_month_t = 58

teradata: interval month

interval_second_t = 59

teradata:interval second

interval_t = 48

Postgresql

interval_year_t = 60

teradata interval year.

interval_year_to_month_t = 61

json_t = 150

jsonb_t = 151

line_t = 62

listType_t = 145

long_raw_t = 67

ansi2003: blob

long_t = 63

long_varbinary_t = 65

long varbinary, mysql MySQL Connector/ODBC defines BLOB values as LONGVARBINARY and TEXT values as LONGVARCHAR.

long_varchar_t = 64

long_vargraphic_t = 68

longblob_t = 66

longtext_t = 69

lseg_t = 70

lvarchar_t = 124

macaddr_t = 71

mapType_t = 147

mediumblob_t = 72

mediumint_t = 73

mediumint, middleint(MySQL) , ansi2003: int

mediumtext_t = 74

money_t = 75

natural_t = 136

naturaln_t = 137

nchar_t = 77

nchar, national char, national character,ansi2003: national character

ncharacter_t = 78

nclob_t = 79

ansi2003: nclob

no_typename_t = 132

ansi2003: tinyint

ntext_t = 80

ntext, national text, ansi2003: nclob

number_t = 82

number, num

numeric_t = 83

ansi2003: numeric

nvarchar2_t = 81

nvarchar2(n)

nvarchar_t = 76

national_char_varying,nchar_varying,nvarchar, ansi2003: national character varying

object_t = 160

oid_t = 84

path_t = 85

period_t = 86

teradata: period(n)

pls_integer_t = 87

plsql pls_integer

point_t = 88

polygon_t = 89

positive_t = 138

positiven_t = 139

raw_t = 90

real_t = 91

ansi2003: real

refcursor_t = 149

row_data_types_t = 127

rowid_t = 92

rowversion_t = 93

self_t = 152

serial8_t = 95

serial_t = 94

set_t = 98

MySQL: set

signed_int_t = 154

signed_integer_t = 155

signed_t = 153

signtype_t = 140

simple_integer_t = 141

smalldatetime_t = 99

smallfloat_t = 97

smallint_t = 100

ansi2003: smallint

smallmoney_t = 101

sql_variant_t = 102

string_t = 144

structType_t = 146

table_t = 103

text_t = 104

time_t = 105

ansi2003: time

time_with_time_zone_t = 106

teradata: time with time zone

timespan_t = 107

timestamp_t = 108

timestamp_with_local_time_zone_t = 109

timestamp with local time zone, Database: Oracle,SQL Server

timestamp_with_time_zone_t = 110

timestamp with time zone, timestamptz, ansi2003: timestamp with time zone

timestamp_without_time_zone_t = 111

timetz_t = 112

time with time zone, ansi2003: time with time zone Databases: teradata

tinyblob_t = 113

tinyint_t = 114

tinytext_t = 115

unionType_t = 148

uniqueidentifier_t = 116

unknown_t = 0

unsigned_int_t = 156

unsigned_integer_t = 157

unsigned_t = 158

urowid_t = 117

varbinary_t = 118

ansi2003: blob

varbit_t = 119

netezza, bit varying

varbyte_t = 120

teradata: varbyte

varchar2_t = 122

ansi2003: character varying

varchar_for_bit_data_t = 123

varchar_t = 121

varchar, char varying, character varying, ansi2003:character varying(n)

vargraphic_t = 126

ansi2003: nchar varying

variant_t = 159

xml_t = 134

xmltype_t = 135

year_t = 133