org.eclipse.datatools.enablement.sybase.asa.schemaobjecteditor.examples
Class SQLDataTypes
java.lang.Object
org.eclipse.datatools.enablement.sybase.asa.schemaobjecteditor.examples.SQLDataTypes
public class SQLDataTypes
- extends java.lang.Object
The class describe all datatypes in ASE12/ASE15/ASA/ASIQ. These datatypes are defined in
String form because, generallly speaking, we can not get the datatype's sql type from database's
systemp tables which are integer.
In addition, a map to JDBC SQL type is designed.
- Author:
- Shi-feng Yu
Method Summary |
static int |
convert2SQLType(java.lang.String typeName)
Convert datatype in String to JDBC SQL type in integer. |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
BINARY
public static final java.lang.String BINARY
- See Also:
- Constant Field Values
BIT
public static final java.lang.String BIT
- See Also:
- Constant Field Values
BIGINT
public static final java.lang.String BIGINT
- See Also:
- Constant Field Values
CHAR
public static final java.lang.String CHAR
- See Also:
- Constant Field Values
CHARACTER
public static final java.lang.String CHARACTER
- See Also:
- Constant Field Values
CHARACTER_VARYING
public static final java.lang.String CHARACTER_VARYING
- See Also:
- Constant Field Values
DATE
public static final java.lang.String DATE
- See Also:
- Constant Field Values
DATETIME
public static final java.lang.String DATETIME
- See Also:
- Constant Field Values
DECIMAL
public static final java.lang.String DECIMAL
- See Also:
- Constant Field Values
DOUBLE
public static final java.lang.String DOUBLE
- See Also:
- Constant Field Values
DOUBLE_PRECISION
public static final java.lang.String DOUBLE_PRECISION
- See Also:
- Constant Field Values
FLOAT
public static final java.lang.String FLOAT
- See Also:
- Constant Field Values
IMAGE
public static final java.lang.String IMAGE
- See Also:
- Constant Field Values
INT
public static final java.lang.String INT
- See Also:
- Constant Field Values
INTEGER
public static final java.lang.String INTEGER
- See Also:
- Constant Field Values
LONG_VARCHAR
public static final java.lang.String LONG_VARCHAR
- See Also:
- Constant Field Values
LONG_BINARY
public static final java.lang.String LONG_BINARY
- See Also:
- Constant Field Values
LONG_VARBINARY
public static final java.lang.String LONG_VARBINARY
- See Also:
- Constant Field Values
LONGSYSNAME
public static final java.lang.String LONGSYSNAME
- See Also:
- Constant Field Values
MONEY
public static final java.lang.String MONEY
- See Also:
- Constant Field Values
NUMERIC
public static final java.lang.String NUMERIC
- See Also:
- Constant Field Values
NCHAR
public static final java.lang.String NCHAR
- See Also:
- Constant Field Values
NATIONAL_CHARACTER
public static final java.lang.String NATIONAL_CHARACTER
- See Also:
- Constant Field Values
NATIONAL_CHAR
public static final java.lang.String NATIONAL_CHAR
- See Also:
- Constant Field Values
NVARCHAR
public static final java.lang.String NVARCHAR
- See Also:
- Constant Field Values
REAL
public static final java.lang.String REAL
- See Also:
- Constant Field Values
SMALLDATETIME
public static final java.lang.String SMALLDATETIME
- See Also:
- Constant Field Values
SMALLMONEY
public static final java.lang.String SMALLMONEY
- See Also:
- Constant Field Values
SYSNAME
public static final java.lang.String SYSNAME
- See Also:
- Constant Field Values
SMALLINT
public static final java.lang.String SMALLINT
- See Also:
- Constant Field Values
TIME
public static final java.lang.String TIME
- See Also:
- Constant Field Values
TIMESTAMP
public static final java.lang.String TIMESTAMP
- See Also:
- Constant Field Values
TEXT
public static final java.lang.String TEXT
- See Also:
- Constant Field Values
TINYINT
public static final java.lang.String TINYINT
- See Also:
- Constant Field Values
UNICHAR
public static final java.lang.String UNICHAR
- See Also:
- Constant Field Values
UNITEXT
public static final java.lang.String UNITEXT
- See Also:
- Constant Field Values
UNIVARCHAR
public static final java.lang.String UNIVARCHAR
- See Also:
- Constant Field Values
UNSIGNED_SMALLINT
public static final java.lang.String UNSIGNED_SMALLINT
- See Also:
- Constant Field Values
UNSIGNED_INT
public static final java.lang.String UNSIGNED_INT
- See Also:
- Constant Field Values
UNSIGNED_BIGINT
public static final java.lang.String UNSIGNED_BIGINT
- See Also:
- Constant Field Values
UNSIGNED_INTEGER
public static final java.lang.String UNSIGNED_INTEGER
- See Also:
- Constant Field Values
UNIQUEIDENTIFIER
public static final java.lang.String UNIQUEIDENTIFIER
- See Also:
- Constant Field Values
UNIQUEIDENTIFIERSTR
public static final java.lang.String UNIQUEIDENTIFIERSTR
- See Also:
- Constant Field Values
VARBINARY
public static final java.lang.String VARBINARY
- See Also:
- Constant Field Values
VARCHAR
public static final java.lang.String VARCHAR
- See Also:
- Constant Field Values
XML
public static final java.lang.String XML
- See Also:
- Constant Field Values
JAVA_LANG_OBJECT
public static final java.lang.String JAVA_LANG_OBJECT
- See Also:
- Constant Field Values
JAVA_SERIALIZARION
public static final java.lang.String JAVA_SERIALIZARION
- See Also:
- Constant Field Values
SQLDataTypes
public SQLDataTypes()
convert2SQLType
public static int convert2SQLType(java.lang.String typeName)
- Convert datatype in String to JDBC SQL type in integer.
- Parameters:
typeName
-
- Returns: