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

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.papai@bsdsupportservice.hu
Phone: +36 30 33-55-735 (Hungary)