Re: problem with Win1251 (Cyrillic)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Dobrena Miteva <d_miteva(at)fullsoft(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: problem with Win1251 (Cyrillic)
Date: 2005-04-10 23:32:58
Message-ID: 200504102332.j3ANWwv27736@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dobrena Miteva wrote:
> Dear Postgre team,
>
>
>
> My name is Mladen Mitev.
>
> I downloaded and installed Postgre SQL 8.0.1 and I found that it did not work with Win1251 (Cyrillic). It did not translate the capital and small letters.
>
> These commands did not work:
>
> ILIKE
>
> lower()
>
> upper()

These are controlled by your locale defined by initdb (look for
LC_COLLATE and LC_CTYPE output from the command pg_controldata) _and_
the encoding you used to create the database. For the above to work
both have to be Win1251. Our documentation goes into detail about this.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ezequiel Tolnay 2005-04-11 00:21:47 Re: Unexpected behaviour of numeric datatype when mixed with,float4,
Previous Message Russell Smith 2005-04-10 22:45:13 Re: BUG #1577: round(dp) function does not round to nearest integer properly