Hi all, I'm trying to integrate data from DBpedia into the German language Database of University Museums And Collections in Germany[1] (hosted and maintained at Humboldt-University Berlin/Hermann von Helmholtz- Zentrum), especially information about persons. Part of this integration is a kind of "Discovery Service", which tries to find relevant Wikipedia entries (URIs) for person records we have in our database of persons which are connected with academic collections[2].
For that, I try to match our person names against labels in DBpedia, using the SPARQL endpoint at http://dbpedia.org/sparql and the Full Text Search option via bif:contains. Problem is, it only works, if there are no special characters like "é" or "ä" in query strings: 37000 Error SQ074: Line 6: syntax error at ',' before ''UTF-8'' Could maybe look somebody into this - is there something wrong on my end, or is it a bug? Following are 2 examples, first not working, then one working (before URL-Encoding everything is UTF-8). Thanks a lot for your help! Martin Stricker, Berlin ### Example not working: SELECT ?uri ?txt WHERE { ?uri rdfs:label ?txt . ?txt bif:contains "'Reinhard' AND 'Kekulé'" . FILTER(LANG(?txt) = "de")} http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&format=json&debug=on&query=PREFIX+%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0A++++PREFIX+dbp%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fproperty%2F%3E%0ASELECT+%3Furi+%3Ftxt+WHERE+%7B+%0A++++++++++++%3Furi+rdfs%3Alabel+%3Ftxt+.++%0A++++++++++++%3Ftxt+bif%3Acontains+%22%27Reinhard%27+AND+%27Kekul%C3%A9%27%22+.+%0A++++++++++++FILTER%28LANG%28%3Ftxt%29+%3D+%22de%22%29%7D Error message: 37000 Error SQ074: Line 6: syntax error at ',' before ''UTF-8'' SPARQL query: define sql:signal-void-variables 1 define input:default-graph-uri <http://dbpedia.org > PREFIX : <http://dbpedia.org/resource/> PREFIX dbp: <http://dbpedia.org/property/> SELECT ?uri ?txt WHERE { ?uri rdfs:label ?txt . ?txt bif:contains "'Reinhard' AND 'Kekulé'" . FILTER(LANG(?txt) = "de")} ### Example working: SELECT ?uri ?txt WHERE { ?uri rdfs:label ?txt . ?txt bif:contains "'Ludwig' AND 'Darmstaedter'" . FILTER(LANG(?txt) = "de")} http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&format=json&debug=on&query=PREFIX+%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0A++++PREFIX+dbp%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fproperty%2F%3E%0ASELECT+%3Furi+%3Ftxt+WHERE+%7B+%0A++++++++++++%3Furi+rdfs%3Alabel+%3Ftxt+.++%0A++++++++++++%3Ftxt+bif%3Acontains+%22%27Ludwig%27+AND+%27Darmstaedter%27%22+.+%0A++++++++++++FILTER%28LANG%28%3Ftxt%29+%3D+%22de%22%29%7D [1] http://publicus.culture.hu-berlin.de/sammlungen/ [2] http://publicus.culture.hu-berlin.de/sammlungen/personen ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Dbpedia-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
