Hello experts,

I am trying to insert the data to Virtuoso quad store via JDBC and
experiencing the issue with non-ASCII characters.
When I executed SPARQL INSERT that contains non-ASCII characters, the
characters are garbled. Is this a known issue?

My environment is following:
- Cent OS 6.3 64bit
- Virtuoso Open Source Edition 6.1.7-rc1.3127 (from github)
- virtjdbc4.jar Version 4.x [Build 3.62] (from
http://ods.openlinksw.com/wiki/main/Main/VOSDownload/virtjdbc4.jar)
- java 1.6.0_43

I set "SQL_UTF8_EXECS = 1" in my virtuoso.ini.

Here is a sample code to reproduce this issue.
-----
import java.sql.*;

public class Sample {
  public static void main(String[] args) throws Exception {
    Class.forName("virtuoso.jdbc4.Driver");
    Connection conn =
DriverManager.getConnection("jdbc:virtuoso://localhost:1111/CHARSET=UTF-8",
"dba", "dba");

    Statement st = conn.createStatement();
    st.execute("sparql CLEAR GRAPH <test>");
    st.execute("sparql INSERT INTO GRAPH <test> { <http://test1/>
<http://xmlns.com/foaf/0.1/name> \"test1\" }");
    st.execute("sparql INSERT INTO GRAPH <test> { <http://test2/>
<http://xmlns.com/foaf/0.1/name> \"\u3066\u3059\u30682\" }");
    st.execute("sparql SELECT * FROM <test> WHERE { ?s ?p ?o }");

    ResultSet rs = st.getResultSet();
    while (rs.next()) {
      System.out.println(rs.getString("o"));
    }
  }
}
-----

Regards,
Shinichi

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to