Gunnar,
There are a variety of things that could be going wrong. But I would
first suspect the fact that you didn't specify what character set to use
in your System.out.println() calls. Because you didn't specify, java
will use its default which may or may not be what you want. You also
don't show how you are getting the data into this table, so the problem
may be that the data is corrupted while being inserted.
--Barry
Gunnar Giesinger wrote:
> hi everybody!
>
> I need to set up a database that should be able to contain values that
> include German special chars (Umlauts like Ää...). I therefore
> created a database with 'LATIN1' as character encoding.
>
> Afterwards I tried to access a table containing only one character
> varying field for test purposes via JDBC:
>
> Class.forName("org.postgresql.Driver");
> String url = "jdbc:postgresql://server:5432/umlaute";
> Properties info = new Properties();
> info.put("user", "usr");
> info.put("password", "pw");
> Connection con = DriverManager.getConnection(url, info);
> Statement stmt = con.createStatement();
> ResultSet rst = stmt.executeQuery("SELECT * FROM test");
> rst.next();
> System.out.println(rst.getString(1));
>
> Everything works fine except instead of all the German special chars
> strange symbols are displayed.
>
> Does anybody know how to fix this problem?
>
> Thanks
>
> john
>
> used system: PostgreSQL 7.3.4 on fedora core 1
> MS Windows Client
> various JDBC drivers tested
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
