Use Unicode. Initialize your databse with unicode encoding:
initdb -E UNICODE -D /your/data/directory
It will also help if your client code handles the data in unicode
encoding. Java is doing it by default, check your client library docs
for this.
If you already initialized your database with a different encoding, you
will most likely have to dump/recreate the db, and restore the data.
HTH,
Csaba.
On Mon, 2003-05-26 at 14:15, Mohan A wrote:
> Hi all,
>
> How can I get Postgresql to handle data in both English language and German language. I am running Postgresql
7.3on Linux.
>
> Thanks in advance for your help.
>
> Mohan