Thread: ...

Hello List!

PostgreSQL 8 does not correctly sort words written in cyrillic. It is a bug I suppose :)

Hi,

Am Montag, den 06.12.2004, 15:07 +0300 schrieb Konstantin Danilov:
> Hello List!
>
> PostgreSQL 8 does not correctly sort words written in cyrillic. It is a bug I suppose :)

No, its not a bug ;) You have to make sure you used the correct locale
while you set up your database cluster (initdb) and also the correct
charset. Then sorting will work.

Regards
Tino

  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.

---559023410-1566752080-1102337279=:28124
Content-Type: TEXT/PLAIN; charset=koi8-r; format=flowed
Content-Transfer-Encoding: 8BIT

On Mon, 6 Dec 2004, Konstantin Danilov wrote:

> Hello List!
>
> PostgreSQL 8 does not correctly sort words written in cyrillic. It is a bug I suppose :)

Probably, it's a problem of your setup.

Here is what I have:

regression=# select version();
                                   version
---------------------------------------------------------------------------
  PostgreSQL 8.0.0rc1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
(1 row)

regression=# select upper('фыва'),'ф' > 'в';
  upper | ?column?
-------+----------
  ФЫВА  | t
(1 row)


>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---559023410-1566752080-1102337279=:28124--