1.0

The feature is supported (for example, through JDBC) but not according to the SQL standard. See explanatory
comment.
Yes*
The feature is partially supported. See comment.Partial
The feature is not supported.No
Does not apply.N/A
Map
SQL-99 Core / SQL-2003 Mandatory
NoteSQL-2003
Mandatory
SQL-99
Core
Feature nameFeature ID
YesYesNumeric data typesE011
YesYesINTEGER and SMALLINT data types
(including all spellings)
E011-01
YesYesREAL, DOUBLE PRECISON, and
FLOAT data types
E011-02
YesYesDECIMAL and NUMERIC data typesE011-03
YesYesArithmetic operatorsE011-04
YesYesNumeric comparisonE011-05
YesYesImplicit casting among the numeric data
types
E011-06
YesYesCharacter data typesE021
YesYesCHARACTER data type (including all
its spellings)
E021-01
YesYesCHARACTER VARYING data type
(including all its spellings)
E021-02
YesYesCharacter literalsE021-03
Called LENGTH. {fn LENGTH(...)} is according to
JDBC specification.
Yes*Yes*CHARACTER_LENGTH functionE021-04
NoNoOCTET_LENGTH functionE021-05
Called SUBSTR. No FROM...FOR, just commas. {fn
SUBSTRING(....)} is according to JDBC specification.
Yes*Yes*SUBSTRING functionE021-06
YesYesCharacter concatenationE021-07
YesYesUPPER and LOWER functionsE021-08
{fn LTRIM(...)} and {fn RTRIM(...)} is according to
JDBC specification.
YesYesTRIM functionE021-09
YesYesImplicit casting among the character data
types
E021-10
Called LOCATE. {fn LOCATE(...)} is according to
JDBC specification.
Yes*Yes*POSITION functionE021-11
585
SQL Language Reference