I'm doing a query in the PostgreSQL database. The database encoding is SQL_ASCII . When I make a query that returns special characters like "Ç" and "~", the following error occurs:
Error Code: 500
Error Desscription: ERROR: invalid byte sequence for encoding "UTF8": 0xc7 0xc3
Exception Type: class org.postgresql.util.PSQLException
Exception Calss: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0xc7 0xc3
How can I configure glassfish to use SQL_ASCII ? I did not find any properties in the console settings that would allow this.