Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using upper() with Greek characters

Using upper() with Greek characters

From
"Panagiotis Piperopoulos"
Date:
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

From
Peter Eisentraut
Date:
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