Re: Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92 - Mailing list pgsql-jdbc

Prasanth Reddy wrote:
>  From log file:
>      ERROR:  invalid byte sequence for encoding "UTF8": 0x92
>      STATEMENT:  SELECT * FROM client_data WHERE status_code = 0 ORDER BY
> client_name, description
>
> Code that causes it:
>          String sql = "SELECT * FROM client_data WHERE status_code = 0 ORDER BY
> client_name, description";
>          ResultSet rs = connection.createStatement().executeQuery(sql);
> *
> *How do I set the connection property?


String connectionString = "jdbc:postgresql://" + host + "/" + database +
"?user=" + username
                          + "&password=" + password + "&loglevel=" + logLevel;

Connection dbConnection = DriverManager.getConnection(connectionString);

Sample Test
http://dandymadeproductions.com/temp/PostgreSQL_JDBC_Test.java

danap.