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
