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
