Hi Julien, I amended an old ADO.Net program we have to insert the query you provided using some special characters of my own (because as stated previously some of the characters in your original mail are not displayed):
virtuosoCommand.CommandText = "SPARQL INSERT IN GRAPH <http://data.linkedevents.org/lastfm/> {<http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Agent> . <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> <http://www.w3.org/2000/01/rdf-schema#label> \"ßÃFlvio Vajman\"@sk . <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> <http://www.w3.org/2002/07/owl#sameAs> <http://www.last.fm> . <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> <http://purl.org/dc/elements/1.1/publisher> <http://www.last.fm> . <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> <http://purl.org/dc/elements/1.1/issued> \"2014-10-20T14:24:10\"^^<http://www.w3.org/2001/XMLSchema#dateTime> . }"; with a connectstring of the form: Persist Security Info=false;Min Pool Size=5;Max Pool Size=60;Charset=utf-8; and the data was inserted correctly: SQL> sparql select * from <http://data.linkedevents.org/lastfm/> where {?s ?p ?o}; s p o VARCHAR VARCHAR VARCHAR _______________________________________________________________________________ http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://xmlns.com/foaf/0.1/Agent http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d http://www.w3.org/2000/01/rdf-schema#label ßÃFlvio Vajman http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d http://www.w3.org/2002/07/owl#sameAs http://www.last.fm http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d http://purl.org/dc/elements/1.1/publisher http://www.last.fm http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d http://purl.org/dc/elements/1.1/issued 2014-10-20 14:24:10 5 Rows. -- 0 msec. SQL> Essentially the only connect string param of interest is "Charset=utf-8;" which is required when querying RDF data ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers > On 23 Oct 2014, at 16:00, Julien Plu <julien....@redaction-developpez.com> > wrote: > > Hi, > > I confirm it's an encoding problem. If i remove all the special characters it > works. Any idea if I have to change a property in the configuration file to > try to solve this ? > > Best. > > -- > Julien Plu > > PhD Student at Eurecom. > Personal webpage: http://jplu.developpez.com > FOAF file : http://jplu.developpez.com/julien > Email address : julien....@eurecom.fr && plu.jul...@gmail.com > Phone : +33493008103 > Twitter : @julienplu > > 2014-10-21 10:00 GMT+02:00 Julien Plu <julien....@redaction-developpez.com>: > Thanks Hugh ! > > In my log I have this encoding problem so maybe it's comming from there. My > version of Virtuoso is 7.1 stable and I tested my application on Windows also > with mono (same version than on linux) and it works. So first I gonna > translate all my strings into UTF-8 and see what's happen. I will let you > know anyway. > > Best. > > -- > Julien Plu > > PhD Student at Eurecom. > Personal webpage: http://jplu.developpez.com > FOAF file : http://jplu.developpez.com/julien > Email address : julien....@eurecom.fr && plu.jul...@gmail.com > Phone : +33493008103 > Twitter : @julienplu > > 2014-10-20 18:07 GMT+02:00 Hugh Williams <hwilli...@openlinksw.com>: > Hi Julien, > > What is the actual string being inserted as what is in the mail seems to have > an encoding issue in my email client ""Fl��vio Vajman"@sk" , maybe you can > provide as file attachment to protect ... > > What is the version of Virtuoso being used (virtuoso-t -? ) , I recall there > was a character encoding issue with rdfdotNet and Virtuoso requiring "UTF-8" > to be set in the connectstring being made by the ADO.Net Provider, but that > was fixed by Rob Vesse some years ago ... > > Problem could being in either layer including mono I suppose ... > > Best Regards > Hugh Williams > Professional Services > OpenLink Software, Inc. // http://www.openlinksw.com/ > Weblog -- http://www.openlinksw.com/blogs/ > LinkedIn -- http://www.linkedin.com/company/openlink-software/ > Twitter -- http://twitter.com/OpenLink > Google+ -- http://plus.google.com/100570109519069333827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > > On 20 Oct 2014, at 13:38, Julien Plu <julien....@redaction-developpez.com> > wrote: > >> Hi all, >> >> Each that I try to make a SPARQL INSERT through my application I have this >> error : >> >> Error : 20/10/2014 14:24:10 : Error on SPARQL insert | INSERT IN GRAPH >> <http://data.linkedevents.org/lastfm/> >> {<http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> >> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> >> <http://xmlns.com/foaf/0.1/Agent> . >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> >> <http://www.w3.org/2000/01/rdf-schema#label> "Fl��vio Vajman"@sk . >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> >> <http://www.w3.org/2002/07/owl#sameAs> <http://www.last.fm> . >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> >> <http://purl.org/dc/elements/1.1/publisher> <http://www.last.fm> . >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> >> <http://purl.org/dc/elements/1.1/issued> >> "2014-10-20T14:24:10"^^<http://www.w3.org/2001/XMLSchema#dateTime> . >> } >> Virtuoso Error: SQL_ERROR >> SQLSTATE: RDFXX >> Message: [Virtuoso .NET Data Provider][Virtuoso Server]Language is specified >> for typed literal in DB.DBA.RDF_MAKE_LONG_OF_TYPEDSQLVAL() >> >> But if I execute the query directly into the isql-v command prompt there is >> no problem. So I'm asking me if it come from Virtuoso or from dotnetRDF lib. >> >> I execute my application with mono 3.2.3 on a Fedora OS. >> >> Thanks in advance. >> >> -- >> Julien Plu >> >> PhD Student at Eurecom. >> Personal webpage: http://jplu.developpez.com >> FOAF file : http://jplu.developpez.com/julien >> Email address : julien....@eurecom.fr && plu.jul...@gmail.com >> Phone : +33493008103 >> Twitter : @julienplu >> ------------------------------------------------------------------------------ >> Comprehensive Server Monitoring with Site24x7. >> Monitor 10 servers for $9/Month. >> Get alerted through email, SMS, voice calls or mobile push notifications. >> Take corrective actions from your mobile device. >> http://p.sf.net/sfu/Zoho_______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > > ------------------------------------------------------------------------------ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
