Hi Renan,
Is there are reason you are using a 06.01.3126 (6.1.1) open source build
which is from Feb 2010 time , as there have been some order by fixes since his
release ? The latest official open source archive on source forge is 06.01.3128
(6.1.2) from Jul 2010 :
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSDownload
Or a 6.1.3 snapshot release can be downloaded from:
ftp://download.openlinksw.com/support/vos/virtuoso-opensource-6-20110105.tar.gz
With the latest fixes, I would suggest you compile and re-test this issue with
...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 13 Jan 2011, at 16:57, Renan Moreira de Oliveira wrote:
> 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?
>
> Driver: 06.01.3126 OpenLink Virtuoso ODBC Driver
>
>
> ORIGINAL (Not use ORDER)
>
> http://example.com/define input:default-graph-uri <http://example.com/>
> define input:inference <http://example.com/ruleset>
>
> select distinct ?s ?label
> FROM <http://example.com/sports/>
>
> {
>
> {
> ?s a <http://example.com/base/player> ; ?p ?o .
> ?o bif:contains "'Ronaldo' AND 'Silva'" .
> ?s l ?label .
> }
>
> }
> LIMIT 100
>
> RESULT
>
> s label
> VARCHAR VARCHAR
> _____________________________________________________________________________
>
> http://example.com/player/53087 Ronaldo - João Ronaldo da Silva
> http://example.com/player/45443 Ronaldo - Ronaldo dos Santos da Silva
> http://example.com/player/42424 Ronaldo Testa - Ronaldo Ferreira da Silva
> http://example.com/player/63408 Rone - José Ronaldo Ferreira da Silva
> http://example.com/player/40875 Ronaldo - Ronaldo da Silva Oliveira
> http://example.com/player/63346 Ronaldo Macapá - Ronaldo da Costa Silva
> http://example.com/player/63153 Nei Júnior - Ronaldo da Silva
> http://example.com/player/44209 Ronaldo Silva - Ronaldo Silva
> http://example.com/player/42158 Ronaldo - Ronaldo Costa da Silva
> http://example.com/player/51145 Ronaldo - Ronaldo Tôrres da Silva
> http://example.com/player/53428 Magal - Ronaldo Luís Pereira Silva
> http://example.com/player/55951 Ronaldo - Ronaldo Afonso da Silva
> http://example.com/player/51834 Ronaldo - Ronaldo da Silva
> http://example.com/player/50610 Ronaldo - Ronaldo Araújo da Silva
> http://example.com/player/50681 Ronaldo - Ronaldo Silva Oliveira
> http://example.com/player/53771 Índio - Ronaldo Odilon da Silva
> http://example.com/player/50710 Ibateguara - Ronaldo José da Silva
> http://example.com/player/51212 Ronaldo - Ronaldo da Costa Silva
> http://example.com/player/46747 Ronaldo - Ronaldo Moraes da Silva
> http://example.com/player/41888 Ronaldo - Ronaldo José da Silva
>
> 20 Rows. -- 2440 msec.
>
>
> Example (ORDER BY)
>
> define input:default-graph-uri <http://example.com/>
> define input:inference <http://example.com/ruleset>
>
> select distinct ?s ?label
> FROM <http://example.com/sports/>
>
> {
>
> {
> ?s a <http://example.com/base/player> ; ?p ?o .
> ?o bif:contains "'Ronaldo' AND 'Silva'" .
> ?s l ?label .
> }
>
> }
> ORDER BY(?label)
> LIMIT 100
>
>
> s label
> VARCHAR VARCHAR
> _______________________________________________________________________________
>
> http://semantica.globo.com/atleta/50710 Ibateguara - Ronaldo José da Silva
> http://semantica.globo.com/atleta/53428 Magal - Ronaldo Luís Pereira Silva
> http://semantica.globo.com/atleta/63153 Nei Júnior - Ronaldo da Silva
> http://semantica.globo.com/atleta/53087 Ronaldo - João Ronaldo da Silva
> http://semantica.globo.com/atleta/55951 Ronaldo - Ronaldo Afonso da Silva
> http://semantica.globo.com/atleta/50610 Ronaldo - Ronaldo Araújo da Silva
> http://semantica.globo.com/atleta/42158 Ronaldo - Ronaldo Costa da Silva
> http://semantica.globo.com/atleta/41888 Ronaldo - Ronaldo José da Silva
> http://semantica.globo.com/atleta/46747 Ronaldo - Ronaldo Moraes da Silva
> http://semantica.globo.com/atleta/50681 Ronaldo - Ronaldo Silva Oliveira
> http://semantica.globo.com/atleta/51145 Ronaldo - Ronaldo Tôrres da Silva
> http://semantica.globo.com/atleta/51212 Ronaldo - Ronaldo da Costa Silva
> http://semantica.globo.com/atleta/51834 Ronaldo - Ronaldo da Silva
> http://semantica.globo.com/atleta/40875 Ronaldo - Ronaldo da Silva
> Oliveira
> http://semantica.globo.com/atleta/45443 Ronaldo - Ronaldo dos Santos da
> Silva
> http://semantica.globo.com/atleta/63346 Ronaldo Macapá - Ronaldo da Costa
> Silva
> http://semantica.globo.com/atleta/44209 Ronaldo Silva - Ronaldo Silva
> http://semantica.globo.com/atleta/42424 Ronaldo Testa - Ronaldo Ferreira
> da Silva
> http://semantica.globo.com/atleta/63408 Rone - José Ronaldo Ferreira da
> Silva
> http://semantica.globo.com/atleta/53771 Índio - Ronaldo Odilon da Silva
>
> 20 Rows. -- 2479 msec.
>
>
>
> Abraços,
> Renan Oliveira
> -----------------------------------------------
> Busca & Semântica - Globo.com
> (21) 2483-6727
> Y! glb_renan
> ------------------------------------------------------------------------------
> 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
