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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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.

Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group