Encoding problem - Mailing list pgsql-jdbc

From Pantelis Natsiavas
Subject Encoding problem
Date
Msg-id 20060830083552.10657.qmail@web50410.mail.yahoo.com
Whole thread Raw
Responses Re: Encoding problem  ("Regász Imre" <linimi@gmail.com>)
List pgsql-jdbc
Hello,
    I am really new to PostgreSQL and I seem to have an encoding problem. I come from Greece and I would like to make queries using greek characters too. I chose to write my database using encoding UTF8 and everything worked just fine creating it, until I tried to make a query using greek characters.
    I tried to make the query through JDBC but this was impossible, receiving a message saying :
                          relation "??????????" does not exist
where the relation's name is in greek characters. Despite fact that the relation is normally created, named and filled using greek characters, I could not make the query. In addition trying to make the same query through the query tool of pgadmin, I receive the same answer and of course null results.
    I don't know if it matters, but I am using Windows XP and PostgreSQL 8.1 with JDBC 3. I have checked everything that has to do with the java part of encoding and I cannot find anything wrong. The fact that I could not make the query through the pgadmin query tool, shows that the problem lays at the PostgreSQL part.
    What could I do? Can anyone help me?

Thank you in advance,
Natsiavas Pantelis


Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.

pgsql-jdbc by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: [HACKERS] [PATCHES] log_statement output for protocol
Next
From: "Regász Imre"
Date:
Subject: Re: Encoding problem