Обсуждение: Using upper() with Greek characters

Поиск
Список
Период
Сортировка

Using upper() with Greek characters

От
"Panagiotis Piperopoulos"
Дата:
Hello.
 
I am new to postgres. I installed 7.3 on a windowsXP machine (I used PgSQL731wina1.exe).
I create a database with Greek encoding iso-8859-7.
 
The sql queries
    SELECT upper(aField) FROM aDatabase
    or
    SELECT lower(aField) FROM aDatabase
 
work ok with US characters but for the Greek characters no conversion is made
 
can anyone help me with this problem
 
Thank you,
    Panagiotis

Re: Using upper() with Greek characters

От
Peter Eisentraut
Дата:
Panagiotis Piperopoulos writes:

> The sql queries
>     SELECT upper(aField) FROM aDatabase
>     or
>     SELECT lower(aField) FROM aDatabase
>
> work ok with US characters but for the Greek characters no conversion is
> made

You would need to set the appropriate locale as well, but Cygwin doesn't
support locales, so you're out of luck.

--
Peter Eisentraut   peter_e@gmx.net