Re: Insert data with greek characters using psql environment

2010/11/12 ΑΠΟΣΤΟΛΟΣ ΛΕΛΕΝΤΖΗΣ <lelentzisapostolos(at)gmail(dot)com>:
> Hello,
>
> I am a new user of PostgreSQL , and i have a problem with encoding settings
> of psql.
> Specifically, i want to insert data with greek characters using psql
> environment.
> I change the enconding settings of psql, writing the following command:
> SET CLIENT_ENCODING TO 'UTF8';
> but i can't insert my data!!
> Can you help me??

You're not using psql under windows, are you? It works horribly on windows.

It'll use a weird legacy encoding such as IBM codepage 850 (that's
what it is on my Irish locale Windows XP, but it's probably something
else for you).

--
Regards,
Peter Geoghegan