db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: 10.3 updates to SQLvsDerbyFeatures
Date Wed, 04 Jul 2007 07:28:17 GMT
>>>>>>>>>>>> Mamta Satoor wrote (2007-07-03 09:30:12):
> Hi Bernt,
> 
> I looked at F691 Collation and translation and IMO we still can not claim
> yes for that feature. 

But I guess we should claim "Partial" with a comment.

> I searched the net and found the following SQL doc
> http://www.cse.iitb.ac.in/dbms/Data/Papers-Other/SQL1999/ansi-iso-9075-2-1999.pdf.
> This pdf talks about F691. (From pdf documentation page number 986) F691
> requires support for COLLATE clause, CREATE COLLATION, DROP COLLATION which
> Derby 10.3 does not support. I have not been able to find more info on F692
> and F451 but I do not think we support those either because I did not add
> any support for character set definition or any other SQL syntax support for
> collation.

F692 and F451 are not defined in SQL-99 but in SQL-2003. I guess "No"
is appropriate here.

> 
> Mamta
> 
> 
> On 7/3/07, Bernt M. Johnsen <Bernt.Johnsen@sun.com> wrote:
> >
> >Hi all,
> >
> >It's time to update http://wiki.apache.org/db-derby/SQLvsDerbyFeatures
> >
> >I have updated
> >  E021-09 TRIM function
> >  E061-04 LIKE predicate
> >  E061-05 LIKE predicate: ESCAPE clause
> >  F281 LIKE enhancements
> >
> >In addition
> >  F691 Collation and translation
> >needs an update, and possibly
> >  F692 Enhanced collation support
> >  F451 Character set definition
> >
> >There may be more too.
> >
> >Bernt
> >--
> >Bernt Marius Johnsen, Database Technology Group,
> >Staff Engineer, Technical Lead Derby/Java DB
> >Sun Microsystems, Trondheim, Norway
> >
> >

-- 
Bernt Marius Johnsen, Database Technology Group, 
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

Mime
View raw message