2 // System.Data.Odbc.OdbcType
\r
7 // Copyright (C) Brian Ritchie, 2002
\r
11 // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
13 // Permission is hereby granted, free of charge, to any person obtaining
14 // a copy of this software and associated documentation files (the
15 // "Software"), to deal in the Software without restriction, including
16 // without limitation the rights to use, copy, modify, merge, publish,
17 // distribute, sublicense, and/or sell copies of the Software, and to
18 // permit persons to whom the Software is furnished to do so, subject to
19 // the following conditions:
21 // The above copyright notice and this permission notice shall be
22 // included in all copies or substantial portions of the Software.
24 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
25 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
26 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
27 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
28 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
29 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
30 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
34 using System.Data.Common;
\r
36 namespace System.Data.Odbc
\r
39 // From the ODBC documentation:
\r
41 // In ODBC 3.x, the identifiers for date, time, and timestamp SQL data types
\r
42 // have changed from SQL_DATE, SQL_TIME, and SQL_TIMESTAMP (with instances of
\r
43 // #define in the header file of 9, 10, and 11) to SQL_TYPE_DATE, SQL_TYPE_TIME,
\r
44 // and SQL_TYPE_TIMESTAMP (with instances of #define in the header file of 91, 92, and 93),
\r
47 // Unmapped SQL Types
\r
49 //#define SQL_FLOAT 6
\r
50 // could map to SQL_DOUBLE?
\r
51 //#define SQL_INTERVAL 10
\r
52 // could map to SmallDateTime?
\r
56 BigInt=-5, // SQL_BIGINT
\r
57 Binary=-2, // SQL_BINARY
\r
60 Date=91, // SQL_TYPE_DATE
\r
61 DateTime=9, // SQL_DATETIME
\r
62 Decimal=3, // SQL_DECIMAL
\r
63 Double=8, // SQL_DOUBLE
\r
64 Image=-4, // SQL_LONGVARBINARY
\r
65 Int=4, // SQL_INTEGER
\r
66 NChar=-95, // SQL_UNICODE_CHAR
\r
67 NText=-97, // SQL_UNICODE_LONGVARCHAR
\r
68 Numeric=2, // SQL_NUMERIC
\r
69 NVarChar=-96, // SQL_UNICODE_VARCHAR
\r
71 SmallDateTime=0,// ??????????????????????????
\r
72 SmallInt=5, // SQL_SMALLINT
\r
73 Time=92, // SQL_TYPE_TIME
\r
74 Text=-1, // SQL_LONGVARCHAR
\r
75 Timestamp=93, // SQL_TYPE_TIMESTAMP
\r
76 TinyInt=-6, // SQL_TINYINT
\r
77 UniqueIdentifier=-11, // SQL_GUID
\r
78 VarBinary=-3, // SQL_VARBINARY
\r
79 VarChar=12 // SQL_VARCHAR
\r