Erwin,
Since you are using 7.1, you will need to ensure that your database is
created with the correct character set. If you issue the sql statement:
select getdatabaseencoding(); in psql this will show you what character
set your database was created with. To store the german special
characters you should ensure that your database is created with the
LATIN1 character set.
thanks,
--Barry
Erwin Ambrosch wrote:
> Hi,
>
> when I store data in postgresql Version 7.1 containig german special
> characters like ä,ö or ü, postgresql substitutes those characters with a
> ? when I perform a SELECT. The Environment variable LANG is set to de_DE.
>
>
> Can anyone say what to do to get support for german special characters.
>
> Thanks Erwin
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>