01: /**
02: * com.mckoi.database.global.SQLTypes 01 Mar 2001
03: *
04: * Mckoi SQL Database ( http://www.mckoi.com/database )
05: * Copyright (C) 2000, 2001, 2002 Diehl and Associates, Inc.
06: *
07: * This program is free software; you can redistribute it and/or
08: * modify it under the terms of the GNU General Public License
09: * Version 2 as published by the Free Software Foundation.
10: *
11: * This program is distributed in the hope that it will be useful,
12: * but WITHOUT ANY WARRANTY; without even the implied warranty of
13: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14: * GNU General Public License Version 2 for more details.
15: *
16: * You should have received a copy of the GNU General Public License
17: * Version 2 along with this program; if not, write to the Free Software
18: * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
19: *
20: * Change Log:
21: *
22: *
23: */package com.mckoi.database.global;
24:
25: /**
26: * A JDBC independant type definition list. This allows the specification of
27: * all JDBC 1.0 and 2.0 types without requiring the JDBC 2.0
28: * 'java.sql.Types' interface.
29: * <p>
30: * The values are compatible with the JDBC 1.0 and 2.0 spec.
31: *
32: * @author Tobias Downer
33: */
34:
35: public interface SQLTypes {
36:
37: public final static int BIT = -7;
38:
39: public final static int TINYINT = -6;
40:
41: public final static int SMALLINT = 5;
42:
43: public final static int INTEGER = 4;
44:
45: public final static int BIGINT = -5;
46:
47: public final static int FLOAT = 6;
48:
49: public final static int REAL = 7;
50:
51: public final static int DOUBLE = 8;
52:
53: public final static int NUMERIC = 2;
54:
55: public final static int DECIMAL = 3;
56:
57: public final static int CHAR = 1;
58:
59: public final static int VARCHAR = 12;
60:
61: public final static int LONGVARCHAR = -1;
62:
63: public final static int DATE = 91;
64:
65: public final static int TIME = 92;
66:
67: public final static int TIMESTAMP = 93;
68:
69: public final static int BINARY = -2;
70:
71: public final static int VARBINARY = -3;
72:
73: public final static int LONGVARBINARY = -4;
74:
75: public final static int NULL = 0;
76:
77: public final static int OTHER = 1111;
78:
79: public final static int JAVA_OBJECT = 2000;
80:
81: public final static int DISTINCT = 2001;
82:
83: public final static int STRUCT = 2002;
84:
85: public final static int ARRAY = 2003;
86:
87: public final static int BLOB = 2004;
88:
89: public final static int CLOB = 2005;
90:
91: public final static int REF = 2006;
92:
93: public final static int BOOLEAN = 16;
94:
95: }
|