bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL
http://www.agensgraph.org
Other
1.33k stars 148 forks source link

Encoding problem with JDBC driver when using "Umlaut" #462

Open Michael4713 opened 5 years ago

Michael4713 commented 5 years ago

When querying nodes with special characters, i.e. Umlauts (e.g. name: "Réné) using the JDBC driver with the query and Java Code

match (n) return n.name
String name = result.getString(1);

returns garbage.

If the whole node is queried then in the Java code the parameter is extracted everything works fine. With the query and Java Code

match (n) return n.name
Vertex object1 = (Vertex)result.getObject(1);
String name = object1.getString("name");

JDBC Driver Configuration

Additional Paramters: unicode=true&encoding=UTF-8 Driver Class: net.bitnine.agensgraph.Driver Driver Version: 1.4.2 Client Encoding (queried via get client_encoding): UTF8 Server Encoding (queried viaget server_encoding): UTF8

bylee5 commented 5 years ago

@Michael4713 In my case, i see Umlauts using the JDBC driver and the command line interface.

Do you see Umlauts through the AgraphGraph interactive terminal(i.e. Agens)?

Michael4713 commented 5 years ago

Hello! If I query it via Squirrel and the AgensBrowser it is displayed correctly. I do not have direct access to the machine to try it via terminal.