You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2007/07/03 14:24:24 UTC
[Db-derby Wiki] Update of "SQLvsDerbyFeatures" by BerntJohnsen
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|| ||