db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "SQLvsDerbyFeatures" by BerntJohnsen
Date Tue, 03 Jul 2007 12:24:24 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by BerntJohnsen:
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures

------------------------------------------------------------------------------
  ||E021-06||SUBSTRING function||<#FFFF00>Yes*||<#FFFF00>Yes*||Called SUBSTR.
xNo FROM...FOR, just commas. {fn SUBSTRING(....)} is according to JDBC specification.  ||
  ||E021-07||Character concatenation||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E021-08||UPPER and LOWER functions||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||E021-09||TRIM function||<#FFFF00>Yes*||<#FFFF00>Yes*||Simple LTRIM and RTRIM
instead. {fn LTRIM(...)} and {fn RTRIM(...)} is according to JDBC specification.  ||
+ ||E021-09||TRIM function||<#FFFF00>Yes (10.4)||<#FFFF00>Yes (10.4)|| Earlier
versions (10.0 - 10.3): Simple LTRIM and RTRIM. {fn LTRIM(...)} and {fn RTRIM(...)} is according
to JDBC specification.  ||
  ||E021-10||Implicit casting among the character data types||<#00FF00>Yes||<#00FF00>Yes||
  ||
  ||E021-11||POSITION function||<#FFFF00>Yes*||<#FFFF00>Yes*||Called LOCATE. {fn
LOCATE(...)} is according to JDBC specification.  ||
  ||E021-12||Character comparison||<#00FF00>Yes||<#00FF00>Yes||   ||

Mime
View raw message