mcs/class/System.Data/System.Data.Odbc/OdbcType.cs

   1 //\r
   2 // System.Data.Odbc.OdbcType\r
   3 //\r
   4 // Author:\r
   5 //   Brian Ritchie\r
   6 //\r
   7 // Copyright (C) Brian Ritchie, 2002\r
   8 //\r
   9 \r
  10 using System.Data;\r
  11 using System.Data.Common;\r
  12 \r
  13 namespace System.Data.Odbc\r
  14 { \r
  15 \r
  16 // From the ODBC documentation:\r
  17 //\r
  18 //      In ODBC 3.x, the identifiers for date, time, and timestamp SQL data types \r
  19 //  have changed from SQL_DATE, SQL_TIME, and SQL_TIMESTAMP (with instances of \r
  20 //  #define in the header file of 9, 10, and 11) to SQL_TYPE_DATE, SQL_TYPE_TIME,\r
  21 //  and SQL_TYPE_TIMESTAMP (with instances of #define in the header file of 91, 92, and 93), \r
  22 //  respectively.\r
  23 \r
  24         // Unmapped SQL Types\r
  25         //\r
  26         //#define SQL_FLOAT                                                             6\r
  27         //      could map to SQL_DOUBLE?\r
  28         //#define SQL_INTERVAL                                                  10\r
  29         //      could map to SmallDateTime?\r
  30 \r
  31         public enum OdbcType : short\r
  32         {\r
  33                 BigInt=-5,              // SQL_BIGINT\r
  34                 Binary=-2,              // SQL_BINARY\r
  35                 Bit=-7,                 // SQL_BIT\r
  36                 Char=1,                 // SQL_CHAR\r
  37                 Date=91,                // SQL_TYPE_DATE\r
  38                 DateTime=9,             // SQL_DATETIME\r
  39                 Decimal=3,              // SQL_DECIMAL\r
  40                 Double=8,               // SQL_DOUBLE\r
  41                 Image=-4,               // SQL_LONGVARBINARY\r
  42                 Int=4,                  // SQL_INTEGER\r
  43                 NChar=-95,              // SQL_UNICODE_CHAR\r
  44                 NText=-97,              // SQL_UNICODE_LONGVARCHAR\r
  45                 Numeric=2,              // SQL_NUMERIC\r
  46                 NVarChar=-96,   // SQL_UNICODE_VARCHAR\r
  47                 Real=7,                 // SQL_REAL\r
  48                 SmallDateTime=0,// ??????????????????????????\r
  49                 SmallInt=5,             // SQL_SMALLINT\r
  50                 Time=92,                // SQL_TYPE_TIME\r
  51                 Text=-1,                // SQL_LONGVARCHAR\r
  52                 Timestamp=93,   // SQL_TYPE_TIMESTAMP\r
  53                 TinyInt=-6,             // SQL_TINYINT\r
  54                 UniqueIndetifier=-11,  // SQL_GUID\r
  55                 VarBinary=-3,   // SQL_VARBINARY\r
  56                 VarChar=12              // SQL_VARCHAR\r
  57         }\r
  58 }\r