You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Steve Ebersole (JIRA)" <de...@db.apache.org> on 2006/08/18 01:33:14 UTC

[jira] Commented: (DERBY-1623) Consider ANSI TRIM implementation

    [ http://issues.apache.org/jira/browse/DERBY-1623?page=comments#action_12428830 ] 
            
Steve Ebersole commented on DERBY-1623:
---------------------------------------

FWIW, an ANSI SQL compliant TRIM function would be fabulous.  But even a REPLACE function would allow JPA providers to emulate the ANSI SQL TRIM functionality.  Right now in Hibernate, for example, we emulate this on SQL Server and Sybase because neither support the full TRIM definition, but each do support LTRIM, RTRIM, and REPLACE which we use to achieve this emulation.

> Consider ANSI TRIM implementation
> ---------------------------------
>
>                 Key: DERBY-1623
>                 URL: http://issues.apache.org/jira/browse/DERBY-1623
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Emmanuel Bernard
>
> JPA is requiring databases to support this ANSI feature esp the ability to chose the trimmed character
> TRIM([ [ LEADING | TRAILING | BOTH ] [ chars ] FROM ] str)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira