Hi Christoph, Yes I do see your problem if I load the sample dataset you provide, but then if I look at the dataset closely it does have some additional character codes on the end of those two subject URIs:
<http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://www.w3.org/2002/07/owl#Ontology> . <http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl#\u00E4\u00F6\u00FC> <http://www.w3.org/2000/01/rdf-schema#comment> "a test class"^^<http://www.w3.org/2001/XMLSchema#string> . <http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl#\u00E4\u00F6\u00FC> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://www.w3.org/2000/01/rdf-schema#Class> . Note: <http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl#\u00E4\u00F6\u00FC> <http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl#\u00E4\u00F6\u00FC> So not surprised these come back as garbage ... $ ../bin/isql 1111 Connected to OpenLink Virtuoso Driver: 06.00.3126 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (Virtuoso), version 0.9849b. Type HELP; for help and EXIT; to exit. SQL> DB.DBA.TTLP (FILE_TO_STRING_OUTPUT ('./test.nt'), 'http://my_graph', 'http://my_graph', 0); Done. -- 214 msec. SQL> SPARQL SELECT ?s FROM <http://my_graph> WHERE { ?s ?p ?o . }; s VARCHAR _______________________________________________________________________________ http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl#äöü> http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl#äöü> 3 Rows. -- 8 msec. SQL> quit; Remove the characters and : $ vi test.nt $ ../bin/isql 1111 Connected to OpenLink Virtuoso Driver: 06.00.3126 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (Virtuoso), version 0.9849b. Type HELP; for help and EXIT; to exit. SQL> DB.DBA.TTLP (FILE_TO_STRING_OUTPUT ('./test.nt'), 'http://my_graph_fixed', 'http://my_graph_fixed', 0); Done. -- 70 msec. SQL> SPARQL SELECT ?s FROM <http://my_graph_fixed> WHERE { ?s ?p ?o . }; s VARCHAR _______________________________________________________________________________ http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl# http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl# 3 Rows. -- 7 msec. SQL> 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 3 Feb 2010, at 14:30, Christoph Rieß wrote: > Hi, > > I'm quite sure there is a problem with the TTLP Import into an empty Graph > via iSQL (e.g. in Conductor or via ODBC); To import data the following > statement is used: > CALL DB.DBA.TTLP (FILE_TO_STRING_OUTPUT ('/tmp/test.nt'), 'http://my_graph', > 'http://my_graph', 0) > because if i do a sparql query like: > SELECT ?s WHERE { ?s ?p ?o . } > then i get as result the resources: > http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl > http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl#äöü> > http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl#äöü> > Check the trailing '>' which surely shoulnd't be there. > > I'm using Opensource Version: 06.00.312 ; Build: Dec 14 2009 > > Normally the Virtuoso Server is queried by an OntoWiki Installation via ODBC. > That's were i initally ran across that bug. (see ontowiki issue as ontowikis > turtle parser suffered from bugs too) > Please try to use the appended data to re-create that bug. Confirm as soon as > possible please. > > mfg CR > <http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl> > <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> > <http://www.w3.org/2002/07/owl#Ontology> . > <http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl#\u00E4\u00F6\u00FC> > <http://www.w3.org/2000/01/rdf-schema#comment> "a test > class"^^<http://www.w3.org/2001/XMLSchema#string> . > <http://www.owl-ontologies.com/2009/10/22/Ontology1256204650.owl#\u00E4\u00F6\u00FC> > <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> > <http://www.w3.org/2000/01/rdf-schema#Class> . > ------------------------------------------------------------------------------ > The Planet: dedicated and managed hosting, cloud storage, colocation > Stay online with enterprise data centers and the best network in the business > Choose flexible plans and management services without long-term contracts > Personal 24x7 support from experience hosting pros just a phone call away. > http://p.sf.net/sfu/theplanet-com_______________________________________________ > Virtuoso-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
