Re: Encoding problem

Thank you Markus. It is unbelievable! I 've lost two days breaking my head over encodings, and the solution was the double quotes!

Thank you all for bothering,
Pantelis

Markus Schaber <schabi(at)logix-tt(dot)com> wrote: Hi, Pantelis,

Pantelis Natsiavas wrote:

> The problem is, that I cannot make a SELECT query through the pgadmin
> tool or the JDBC, using the same greek characters!

Have you tried quoting the table names in double quotes? Like in:

SELECT * FROM "myGreekTable";

Quoted identifiers are a source of trouble in SQL databases...

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

---------------------------------
Ring'em or ping'em. Make PC-to-phone calls as low as 1¢/min with Yahoo! Messenger with Voice.