[ARCHIBUS] Comparison of Data Types

AfmType	Sybase	Oracle	SQLServer	Size Matters	Decimals Matters
SQL_CHAR	"CHAR(%d)"	"VARCHAR2(%d)"	"CHAR(%d)"	TRUE	FALSE
SQL_NUMERIC	"NUMERIC(%d,%d)"	"NUMBER(%d,%d)"	"NUMERIC(%d,%d)"	TRUE	TRUE
SQL_DECIMAL	"NUMERIC(%d,%d)"	"NUMBER(%d,%d)"	"NUMERIC(%d,%d)"	TRUE	TRUE
SQL_INTEGER	"INTEGER"	"NUMBER(*,0)"	"INTEGER"	FALSE	FALSE
SQL_SMALLINT	"SMALLINT"	"NUMBER(*,0)"	"SMALLINT"	FALSE	FALSE
SQL_FLOAT	"FLOAT"	"FLOAT"	"FLOAT(53)"	FALSE	FALSE
SQL_REAL	"REAL"	"REAL"	"REAL"	FALSE	FALSE
SQL_DOUBLE	"DOUBLE"	"NUMBER(%d,%d)"	"FLOAT(53)"	FALSE	FALSE
SQL_DATE	"DATE"	"DATE"	"DATETIME"	FALSE	FALSE
SQL_TIME	"TIME"	"DATE"	"DATETIME"	FALSE	FALSE
SQL_TIMESTAMP	"DATE"	"DATE"	"DATETIME"	FALSE	FALSE
SQL_VARCHAR	"VARCHAR(%d)"	"VARCHAR2(%d)"	"VARCHAR(%d)"	TRUE	FALSE
SQL_LONGVARCHAR(-1)	"VARCHAR(%d)"	"VARCHAR2(%d)"	"VARCHAR(%d)"	TRUE	FALSE