Skip site navigation (1) Skip section navigation (2)

BUG #1685: sorting problem with LATIN2

From: "Piotr Drozdowski" <piotr(at)ben(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1685: sorting problem with LATIN2
Date: 2005-05-27 22:00:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1685
Logged by:          Piotr Drozdowski
Email address:      piotr(at)ben(dot)pl
PostgreSQL version: 8.03
Operating system:   Windows 2000 Prof.
Description:        sorting problem with LATIN2

If table is created with ENCODING in 'LATIN2' 
I've got problem with sorting varchar(xx) fields
with "polish" letter as first char and it is only
problem with letter "". Rows with that letter are
always at the top rows in ascending sorting.
That situation is absent if table is crated as
WIN1250 on PostgreSQL 8.03.
I have no problem with ENCODING in LATIN2 on 
Linux and PostgreSQL 7.4 too.

sorry for my bad english

pgsql-bugs by date

Next:From: shdDate: 2005-05-27 22:20:17
Subject: adding users
Previous:From: FREMAUX Benjamin SOFRECOMDate: 2005-05-27 15:22:12
Subject: Re: BUG #1681: Selection problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group