Hi Bernt, I updated the page for F691with Partial support and a short comment.
thanks, Mamta On 7/4/07, Bernt M. Johnsen <[EMAIL PROTECTED]> wrote:
>>>>>>>>>>>> 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 <[EMAIL PROTECTED]> 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
