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

Reply via email to