getTables() doesn't handle umlauts correctly - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject getTables() doesn't handle umlauts correctly
Date
Msg-id icc7cc$19a$1@dough.gmane.org
Whole thread Raw
Responses Re: getTables() doesn't handle umlauts correctly
List pgsql-jdbc
Hi,

I noticed that the driver will return incorrect values for table names that contain umlauts. Consider the following
code:

Class.forName("org.postgresql.Driver");
con = DriverManager.getConnection("jdbc:postgresql://localhost/postgres", "postgres", "password");
stmt = con.createStatement();
stmt.executeUpdate("create table public.umlaut_test_ö (id integer)");
rs = con.getMetaData().getTables(null, "public", "umlaut_test%", null);
while (rs.next())
{
    System.out.println(rs.getString("TABLE_NAME"));
}

It will not display the table name correctly.

Now on the console this might be an encoding problem of the client, but the name is also not displayed correctly, when
e.g.using a Swing JLabel component which is fully UTF-8 compatible. 

Is there a connection parameter for the driver to return that correctly or is this a driver bug?

I'm using the 9.0-801 driver with a 9.0.1 database running on Windows XP

Regards
Thomas

pgsql-jdbc by date:

Previous
From: Radosław Smogura
Date:
Subject: Experimental JDBC driver
Next
From: Itagaki Takahiro
Date:
Subject: Re: [HACKERS] Support for JDBC setQueryTimeout, et al.