[Darmok]

Hello,

I've been trying to sort a field alphabetically in Postgres 7.3.3 on a
Mandrake 8.1 box.

As you can see below, Music comes after Musical, and that is not alphabetical order. Does anyone know how to get it in alphabetical order? The database is using SQL_ASCII encoding.

Thanks in advance for any help!

AugPERdb=# \d test
Attribute | Type | Modifier
-----------+------------------------+----------
title | character varying(255) |

AugPERdb=# select * from test order by lower(title);
title
-------------------------
Musical Quarterly
Musical Times
Music and Letters
Music & Anthropology
Music Educators Journal
Music Perception
Music Week
(7 rows)

[karim2k]

Try with varchar, In my databse working with varcahr never show errors , the order is alright even with arabic encoding !

[Darmok]

Thanks, this is the query I used.

SELECT * from test order by lower(title::character);

Works great!