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
|
Список | 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 по дате отправления: