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

Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD

From: Adam PAPAI <adam(dot)papai(at)bsdsupportservice(dot)hu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD
Date: 2011-02-06 10:30:10
Message-ID: 4D4E7832.4050400@bsdsupportservice.hu (view raw or flat)
Thread:
Lists: pgsql-bugs
Adam PAPAI wrote:

The correct encoding of the values are:

INSERT INTO test (name)  values ( 'a' );
INSERT INTO test (name)  values ( 'á' );
INSERT INTO test (name)  values ( 'b' );
INSERT INTO test (name)  values ( 'c' );
INSERT INTO test (name)  values ( 'd' );
INSERT INTO test (name)  values ( 'e' );
INSERT INTO test (name)  values ( 'é' );
INSERT INTO test (name)  values ( 'f' );
INSERT INTO test (name)  values ( 'g' );
INSERT INTO test (name)  values ( 'h' );

I forgot to change the encoding of my mail client.

test=# select * from test order by name asc;
 idn | name
-----+------
   1 | a
   3 | b
   4 | c
   5 | d
   6 | e
   8 | f
   9 | g
  10 | h
   2 | á
   7 | é
(10 rows)


-- 
Adam PAPAI
BSD Support Service
http://www.bsdsupportservice.hu
E-mail: adam(dot)papai(at)bsdsupportservice(dot)hu
Phone: +36 30 33-55-735 (Hungary)

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-02-06 16:06:10
Subject: Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD
Previous:From: Adam PAPAIDate: 2011-02-06 10:23:57
Subject: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD

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