// // System.Data.Odbc.OdbcType // // Author: // Brian Ritchie // // Copyright (C) Brian Ritchie, 2002 // using System.Data; using System.Data.Common; namespace System.Data.Odbc { // From the ODBC documentation: // // In ODBC 3.x, the identifiers for date, time, and timestamp SQL data types // have changed from SQL_DATE, SQL_TIME, and SQL_TIMESTAMP (with instances of // #define in the header file of 9, 10, and 11) to SQL_TYPE_DATE, SQL_TYPE_TIME, // and SQL_TYPE_TIMESTAMP (with instances of #define in the header file of 91, 92, and 93), // respectively. // Unmapped SQL Types // //#define SQL_FLOAT 6 // could map to SQL_DOUBLE? //#define SQL_INTERVAL 10 // could map to SmallDateTime? public enum OdbcType : short { BigInt=-5, // SQL_BIGINT Binary=-2, // SQL_BINARY Bit=-7, // SQL_BIT Char=1, // SQL_CHAR Date=91, // SQL_TYPE_DATE DateTime=9, // SQL_DATETIME Decimal=3, // SQL_DECIMAL Double=8, // SQL_DOUBLE Image=-4, // SQL_LONGVARBINARY Int=4, // SQL_INTEGER NChar=-95, // SQL_UNICODE_CHAR NText=-97, // SQL_UNICODE_LONGVARCHAR Numeric=2, // SQL_NUMERIC NVarChar=-96, // SQL_UNICODE_VARCHAR Real=7, // SQL_REAL SmallDateTime=0,// ?????????????????????????? SmallInt=5, // SQL_SMALLINT Time=92, // SQL_TYPE_TIME Text=-1, // SQL_LONGVARCHAR Timestamp=93, // SQL_TYPE_TIMESTAMP TinyInt=-6, // SQL_TINYINT UniqueIndetifier=-11, // SQL_GUID VarBinary=-3, // SQL_VARBINARY VarChar=12 // SQL_VARCHAR } }