Skip site navigation (1) Skip section navigation (2)

Re: German Special Chars (Umlaute)

From: Barry Lind <blind(at)xythos(dot)com>
To: Gunnar Giesinger <mailinglists(at)gmx(dot)at>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: German Special Chars (Umlaute)
Date: 2004-05-05 03:22:04
Message-ID: 40985DDC.9090601@xythos.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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 &Auml;&auml;...). 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


In response to

pgsql-jdbc by date

Next:From: Tom LaneDate: 2004-05-05 13:49:18
Subject: Re: Result Set Cursor Patch
Previous:From: Gunnar GiesingerDate: 2004-05-04 21:54:34
Subject: German Special Chars (Umlaute)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group