static DataTypeInfo()
{
//Char = new DataTypeChar ("CHAR", VirtDbType.Char, System.Data.DbType.AnsiStringFixedLength, CLI.SqlType.SQL_CHAR, false);
Char = new DataTypeChar("CHAR", VirtDbType.Char, System.Data.DbType.AnsiString, CLI.SqlType.SQL_CHAR, false);
VarChar = new DataTypeChar("VARCHAR", VirtDbType.VarChar, System.Data.DbType.AnsiString, CLI.SqlType.SQL_VARCHAR, false);
LongVarChar = new DataTypeChar("LONG VARCHAR", VirtDbType.LongVarChar, System.Data.DbType.AnsiString, CLI.SqlType.SQL_LONGVARCHAR, true);
//NChar = new DataTypeWide ("NCHAR", VirtDbType.NChar, System.Data.DbType.StringFixedLength, CLI.SqlType.SQL_WCHAR, false);
NChar = new DataTypeWide("NCHAR", VirtDbType.NChar, System.Data.DbType.String, CLI.SqlType.SQL_WCHAR, false);
NVarChar = new DataTypeWide("NVARCHAR", VirtDbType.NVarChar, System.Data.DbType.String, CLI.SqlType.SQL_WVARCHAR, false);
NLongVarChar = new DataTypeWide("LONG NVARCHAR", VirtDbType.LongNVarChar, System.Data.DbType.String, CLI.SqlType.SQL_WVARCHAR, true);
Binary = new DataTypeBinary("BINARY", VirtDbType.Binary, System.Data.DbType.Binary, CLI.SqlType.SQL_BINARY, false);
VarBinary = new DataTypeBinary("VARBINARY", VirtDbType.VarBinary, System.Data.DbType.Binary, CLI.SqlType.SQL_VARBINARY, false);
LongVarBinary = new DataTypeBinary("LONG VARBINARY", VirtDbType.LongVarBinary, System.Data.DbType.Binary, CLI.SqlType.SQL_LONGVARBINARY, true);
BigInt = new DataTypeBigInt("BIGINT", VirtDbType.BigInt, System.Data.DbType.Int64, CLI.SqlType.SQL_BIGINT);
Integer = new DataTypeInt32("INTEGER", VirtDbType.Integer, System.Data.DbType.Int32, CLI.SqlType.SQL_INTEGER);
SmallInt = new DataTypeInt16("SMALLINT", VirtDbType.SmallInt, System.Data.DbType.Int16, CLI.SqlType.SQL_SMALLINT);
Real = new DataTypeSingle("REAL", VirtDbType.Real, System.Data.DbType.Single, CLI.SqlType.SQL_REAL);
Float = new DataTypeDouble("FLOAT", VirtDbType.Float, System.Data.DbType.Double, CLI.SqlType.SQL_FLOAT);
Double = new DataTypeDouble("DOUBLE", VirtDbType.Float, System.Data.DbType.Double, CLI.SqlType.SQL_DOUBLE);
//Decimal = new DataTypeNumeric ("DECIMAL", VirtDbType.Decimal, System.Data.DbType.Decimal, CLI.SqlType.SQL_DECIMAL);
Numeric = new DataTypeNumeric("NUMERIC", VirtDbType.Numeric, System.Data.DbType.Decimal, CLI.SqlType.SQL_NUMERIC);
Date = new DataTypeDate("DATE", VirtDbType.Date, System.Data.DbType.Date, CLI.SqlType.SQL_TYPE_DATE);
Time = new DataTypeTime("TIME", VirtDbType.Time, System.Data.DbType.Time, CLI.SqlType.SQL_TYPE_TIME);
DateTime = new DataTypeDateTime("DATETIME", VirtDbType.DateTime, System.Data.DbType.DateTime, CLI.SqlType.SQL_TYPE_TIMESTAMP);
Timestamp = new DataTypeTimestamp("TIMESTAMP", VirtDbType.TimeStamp, System.Data.DbType.Binary, CLI.SqlType.SQL_BINARY);
Xml = new DataTypeXml("LONG XML", VirtDbType.Xml, System.Data.DbType.String, CLI.SqlType.SQL_WVARCHAR);
}
static DataTypeInfo ()
{
//Char = new DataTypeChar ("CHAR", VirtDbType.Char, System.Data.DbType.AnsiStringFixedLength, CLI.SqlType.SQL_CHAR, false);
Char = new DataTypeChar ("CHAR", VirtDbType.Char, System.Data.DbType.AnsiString, CLI.SqlType.SQL_CHAR, false);
VarChar = new DataTypeChar ("VARCHAR", VirtDbType.VarChar, System.Data.DbType.AnsiString, CLI.SqlType.SQL_VARCHAR, false);
LongVarChar = new DataTypeChar ("LONG VARCHAR", VirtDbType.LongVarChar, System.Data.DbType.AnsiString, CLI.SqlType.SQL_LONGVARCHAR, true);
//NChar = new DataTypeWide ("NCHAR", VirtDbType.NChar, System.Data.DbType.StringFixedLength, CLI.SqlType.SQL_WCHAR, false);
NChar = new DataTypeWide ("NCHAR", VirtDbType.NChar, System.Data.DbType.String, CLI.SqlType.SQL_WCHAR, false);
NVarChar = new DataTypeWide ("NVARCHAR", VirtDbType.NVarChar, System.Data.DbType.String, CLI.SqlType.SQL_WVARCHAR, false);
NLongVarChar = new DataTypeWide ("LONG NVARCHAR", VirtDbType.LongNVarChar, System.Data.DbType.String, CLI.SqlType.SQL_WVARCHAR, true);
Binary = new DataTypeBinary ("BINARY", VirtDbType.Binary, System.Data.DbType.Binary, CLI.SqlType.SQL_BINARY, false);
VarBinary = new DataTypeBinary ("VARBINARY", VirtDbType.VarBinary, System.Data.DbType.Binary, CLI.SqlType.SQL_VARBINARY, false);
LongVarBinary = new DataTypeBinary ("LONG VARBINARY", VirtDbType.LongVarBinary, System.Data.DbType.Binary, CLI.SqlType.SQL_LONGVARBINARY, true);
BigInt = new DataTypeBigInt ("BIGINT", VirtDbType.BigInt, System.Data.DbType.Int64, CLI.SqlType.SQL_BIGINT);
Integer = new DataTypeInt32 ("INTEGER", VirtDbType.Integer, System.Data.DbType.Int32, CLI.SqlType.SQL_INTEGER);
SmallInt = new DataTypeInt16 ("SMALLINT", VirtDbType.SmallInt, System.Data.DbType.Int16, CLI.SqlType.SQL_SMALLINT);
Real = new DataTypeSingle ("REAL", VirtDbType.Real, System.Data.DbType.Single, CLI.SqlType.SQL_REAL);
Float = new DataTypeDouble ("FLOAT", VirtDbType.Float, System.Data.DbType.Double, CLI.SqlType.SQL_FLOAT);
Double = new DataTypeDouble ("DOUBLE", VirtDbType.Float, System.Data.DbType.Double, CLI.SqlType.SQL_DOUBLE);
//Decimal = new DataTypeNumeric ("DECIMAL", VirtDbType.Decimal, System.Data.DbType.Decimal, CLI.SqlType.SQL_DECIMAL);
Numeric = new DataTypeNumeric ("NUMERIC", VirtDbType.Numeric, System.Data.DbType.Decimal, CLI.SqlType.SQL_NUMERIC);
Date = new DataTypeDate ("DATE", VirtDbType.Date, System.Data.DbType.Date, CLI.SqlType.SQL_TYPE_DATE);
Time = new DataTypeTime ("TIME", VirtDbType.Time, System.Data.DbType.Time, CLI.SqlType.SQL_TYPE_TIME);
DateTime = new DataTypeDateTime ("DATETIME", VirtDbType.DateTime, System.Data.DbType.DateTime, CLI.SqlType.SQL_TYPE_TIMESTAMP);
Timestamp = new DataTypeTimestamp ("TIMESTAMP", VirtDbType.TimeStamp, System.Data.DbType.Binary, CLI.SqlType.SQL_BINARY);
Xml = new DataTypeXml ("LONG XML", VirtDbType.Xml, System.Data.DbType.String, CLI.SqlType.SQL_WVARCHAR);
}