getTables() doesn't handle umlauts correctly

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема getTables() doesn't handle umlauts correctly
Дата
Msg-id icc7cc$19a$1@dough.gmane.org
обсуждение исходный текст
Ответы Re: getTables() doesn't handle umlauts correctly  (Lew <noone@lewscanon.com>)
Список 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 по дате отправления:

Предыдущее
От: Radosław Smogura
Дата:
Сообщение: Experimental JDBC driver
Следующее
От: Itagaki Takahiro
Дата:
Сообщение: Re: [HACKERS] Support for JDBC setQueryTimeout, et al.