Hi Julien, Your reply is unclear, where and how are you specifying the charset, is this is dotNetRDF layer or are you making a direct ADO.Net connection, as I would eliminate dotNetRDF to prove this can be done in the ADO.Net layer first and then work upwards to dotNetRDF ...
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 27 Oct 2014, at 14:39, Julien Plu <julien....@redaction-developpez.com> > wrote: > > It doesn't works even if I precise the charset :-( > > -- > Julien Plu > > PhD Student at Eurecom. > Personal webpage: http://jplu.developpez.com <http://jplu.developpez.com/> > FOAF file : http://jplu.developpez.com/julien > <http://jplu.developpez.com/julien> > Email address : julien....@eurecom.fr <mailto:julien....@eurecom.fr> && > plu.jul...@gmail.com <mailto:plu.jul...@gmail.com> > Phone : +33493008103 > Twitter : @julienplu > > 2014-10-27 10:11 GMT+01:00 Julien Plu <julien....@redaction-developpez.com > <mailto:julien....@redaction-developpez.com>>: > 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 <http://jplu.developpez.com/> > FOAF file : http://jplu.developpez.com/julien > <http://jplu.developpez.com/julien> > Email address : julien....@eurecom.fr <mailto:julien....@eurecom.fr> && > plu.jul...@gmail.com <mailto:plu.jul...@gmail.com> > Phone : +33493008103 <tel:%2B33493008103> > Twitter : @julienplu > > 2014-10-26 20:59 GMT+01:00 Hugh Williams <hwilli...@openlinksw.com > <mailto: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/lastfm/>> > {<http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d>> > <http://www.w3.org/1999/02/22-rdf-syntax-ns#type > <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>> > <http://xmlns.com/foaf/0.1/Agent <http://xmlns.com/foaf/0.1/Agent>> . > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d>> > <http://www.w3.org/2000/01/rdf-schema#label > <http://www.w3.org/2000/01/rdf-schema#label>> \"ßÃFlvio Vajman\"@sk . > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d>> > <http://www.w3.org/2002/07/owl#sameAs <http://www.w3.org/2002/07/owl#sameAs>> > <http://www.last.fm <http://www.last.fm/>> . > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d>> > <http://purl.org/dc/elements/1.1/publisher > <http://purl.org/dc/elements/1.1/publisher>> <http://www.last.fm > <http://www.last.fm/>> . > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d>> > <http://purl.org/dc/elements/1.1/issued > <http://purl.org/dc/elements/1.1/issued>> > \"2014-10-20T14:24:10\"^^<http://www.w3.org/2001/XMLSchema#dateTime > <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/ > <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://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> > http://www.w3.org/1999/02/22-rdf-syntax-ns#type > <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> > http://xmlns.com/foaf/0.1/Agent <http://xmlns.com/foaf/0.1/Agent> > http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> > http://www.w3.org/2000/01/rdf-schema#label > <http://www.w3.org/2000/01/rdf-schema#label> > ßÃFlvio Vajman > http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> > http://www.w3.org/2002/07/owl#sameAs > <http://www.w3.org/2002/07/owl#sameAs> > http://www.last.fm <http://www.last.fm/> > http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> > http://purl.org/dc/elements/1.1/publisher > <http://purl.org/dc/elements/1.1/publisher> > http://www.last.fm <http://www.last.fm/> > http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d> > http://purl.org/dc/elements/1.1/issued > <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/ > <http://www.openlinksw.com/> > Weblog -- http://www.openlinksw.com/blogs/ > <http://www.openlinksw.com/blogs/> > LinkedIn -- http://www.linkedin.com/company/openlink-software/ > <http://www.linkedin.com/company/openlink-software/> > Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink> > Google+ -- http://plus.google.com/100570109519069333827/ > <http://plus.google.com/100570109519069333827/> > Facebook -- http://www.facebook.com/OpenLinkSoftware > <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 > > <mailto: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 <http://jplu.developpez.com/> > > FOAF file : http://jplu.developpez.com/julien > > <http://jplu.developpez.com/julien> > > Email address : julien....@eurecom.fr <mailto:julien....@eurecom.fr> && > > plu.jul...@gmail.com <mailto:plu.jul...@gmail.com> > > Phone : +33493008103 <tel:%2B33493008103> > > Twitter : @julienplu > > > > 2014-10-21 10:00 GMT+02:00 Julien Plu <julien....@redaction-developpez.com > > <mailto: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 <http://jplu.developpez.com/> > > FOAF file : http://jplu.developpez.com/julien > > <http://jplu.developpez.com/julien> > > Email address : julien....@eurecom.fr <mailto:julien....@eurecom.fr> && > > plu.jul...@gmail.com <mailto:plu.jul...@gmail.com> > > Phone : +33493008103 <tel:%2B33493008103> > > Twitter : @julienplu > > > > 2014-10-20 18:07 GMT+02:00 Hugh Williams <hwilli...@openlinksw.com > > <mailto: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/ > > <http://www.openlinksw.com/> > > Weblog -- http://www.openlinksw.com/blogs/ > > <http://www.openlinksw.com/blogs/> > > LinkedIn -- http://www.linkedin.com/company/openlink-software/ > > <http://www.linkedin.com/company/openlink-software/> > > Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink> > > Google+ -- http://plus.google.com/100570109519069333827/ > > <http://plus.google.com/100570109519069333827/> > > Facebook -- http://www.facebook.com/OpenLinkSoftware > > <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 > > <mailto: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/lastfm/>> > >> {<http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d>> > >> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type > >> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>> > >> <http://xmlns.com/foaf/0.1/Agent <http://xmlns.com/foaf/0.1/Agent>> . > >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d>> > >> <http://www.w3.org/2000/01/rdf-schema#label > >> <http://www.w3.org/2000/01/rdf-schema#label>> "Fl��vio Vajman"@sk . > >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d>> > >> <http://www.w3.org/2002/07/owl#sameAs > >> <http://www.w3.org/2002/07/owl#sameAs>> <http://www.last.fm > >> <http://www.last.fm/>> . > >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d>> > >> <http://purl.org/dc/elements/1.1/publisher > >> <http://purl.org/dc/elements/1.1/publisher>> <http://www.last.fm > >> <http://www.last.fm/>> . > >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d > >> <http://data.linkedevents.org/agent/60f13cb8-004f-498d-9e8e-0c5b6331c92d>> > >> <http://purl.org/dc/elements/1.1/issued > >> <http://purl.org/dc/elements/1.1/issued>> > >> "2014-10-20T14:24:10"^^<http://www.w3.org/2001/XMLSchema#dateTime > >> <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 <http://jplu.developpez.com/> > >> FOAF file : http://jplu.developpez.com/julien > >> <http://jplu.developpez.com/julien> > >> Email address : julien....@eurecom.fr <mailto:julien....@eurecom.fr> && > >> plu.jul...@gmail.com <mailto:plu.jul...@gmail.com> > >> Phone : +33493008103 <tel:%2B33493008103> > >> 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_______________________________________________ > >> <http://p.sf.net/sfu/Zoho_______________________________________________> > >> Virtuoso-users mailing list > >> Virtuoso-users@lists.sourceforge.net > >> <mailto:Virtuoso-users@lists.sourceforge.net> > >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > >> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users> > > > > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > Virtuoso-users mailing list > > Virtuoso-users@lists.sourceforge.net > > <mailto:Virtuoso-users@lists.sourceforge.net> > > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > <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
