Al Eridani <al.eridani@xxxxxxxxx> writes: > What Tulio is saying is that 'leon' and 'león' are the same thing from > the point of view of sorting in Spanish, but his PostgreSQL seems to > think that 'leon' goes before 'león'. Postgres never considers that two distinct strings are "equal". If the locale setting considers these equal (which isn't entirely clear from the given evidence), PG would then sort them on the basis of their character code values. A possible workaround if you need to consider them equal is to strip the accents before sorting (ie, something like "ORDER BY to_ascii(col)") but this may well throw away more information than you want ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
