Hello Alex, Right now Virtuoso supports "traditional" SQL collations for single-char and wide varchars, but not for UTF-8. SPARQL does not offer any collation handling ATM. I intend to make (better sooner than later) three things: 1) implement a proxy BIF function that will make a call of specified XPATH/XQuery function from SQL 2) implement a special support for this function in SPARQL-to-SQL preprocessor so one can freely use XPATH functions in SPARQL. 3) let XQuery collation-based functions get RDF literals as arguments.
Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2011-01-17 at 10:53 +0000, Alex Rodriguez Lopez wrote: > Hi there! > > I once inquired about ORDER BY (using portuguese characters too: UTF-8) > at the DBpedia mailing list, the same thing was happening to me when I > queried DBpedia's SPARQL end point (accented characters going directly > to the end), as I assume conparison is made based on byte order instead > of using collation tables or more ellaborate sorting algorithms. Me too, > I'm really interested in these features included in Virtuoso. > > It would be really nice if Virtuoso would support different collations > for ordering (much like these ones > http://www.collation-charts.org/mysql60/ ), or just this one ( > http://www.unicode.org/reports/tr10/ ) which I guess would do the trick > most times. > > So +1 for UTF-8 sorting :D > > Regards, > > Alex > > Renan Moreira de Oliveira, 14-01-2011 20:46: > > Hello Ivan, > > > > Have an estimated delivery of this function? > > I'm needing this function for my current project. > > > > Thanks. > > > > Best Regards, > > Renan Oliveira > > ----------------------------------------------- > > Busca & Semântica - Globo.com > > +55 21 2483-6727 > > Y! glb_renan > > > > > > 2011/1/14 Ivan Mikhailov <[email protected] > > <mailto:[email protected]>> > > > > Hello Renan, > > > > I'm writing now some additional functions for removal of accents and > > other Unicode NSMs (non-spacing modifiers) from strings, so there will > > be possible to use ORDER BY (bif:some-function (?label)) > > > > OTOH, there will be no setting to make this behavior default. > > > > Best Regards, > > > > Ivan Mikhailov > > OpenLink Software > > http://virtuoso.openlinksw.com > > > > > > Hi Aldo, Ivan Mikhailov and Virtuoso Users. > > > > > > > > Can you help me in using the ORDER BY? > > > > He is by default case and accents sensitive?! > > > > Is there any way to bypass this setting? > > > > > > > > > > > > > > ------------------------------------------------------------------------------ > > Protect Your Site and Customers from Malware Attacks > > Learn about various malware tactics and how to avoid them. Understand > > malware threats, the impact they can have on your business, and how you > > can protect your company and customers by using code signing. > > http://p.sf.net/sfu/oracle-sfdevnl > > > > > > > > _______________________________________________ > > Virtuoso-users mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > ------------------------------------------------------------------------------ > Protect Your Site and Customers from Malware Attacks > Learn about various malware tactics and how to avoid them. Understand > malware threats, the impact they can have on your business, and how you > can protect your company and customers by using code signing. > http://p.sf.net/sfu/oracle-sfdevnl > _______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
