AnsweredAssumed Answered

JDBC Encoding

Question asked by alr2 on Jan 27, 2017
Latest reply on Jan 29, 2017 by user19752

I use JDBC to access FileMaker Server.

 

 

It seems to have an error with the encoding but I don't know how to handle this.

 

 

When I run this query: 'SELECT "qté" FROM "facture" FETCH FIRST 1 ROWS ONLY'

 

 

I get this error:

 

 

Failed to execute: SELECT qt├® FROM "facture" FETCH FIRST 1 ROWS ONLY because: [FileMaker][FileMaker JDBC] FQL0001/(1:17): There is an error in the syntax of the query.

Caught: com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] FQL0001/(1:17): There is an error in the syntax of the query.

 

 

 

 

When I run select * it returns qté as column name.

 

 

Is there a way to tell the driver to use utf-8 ? Should I configure something in FMP to set the encoding ? I'm lost here.

 

 

Thanks in advance

Outcomes