Hi Hugh, Thanks for this hint, i gonna test it with mono on the Linux machine to see if adding "Charset=utf-8" to the connect string is enough and I will let you know if it changes something or not.
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 <plu.jul...@gmail.com>* Phone : +33493008103 Twitter : @julienplu 2014-10-26 20:59 GMT+01:00 Hugh Williams <hwilli...@openlinksw.com>: > 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 > >
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users