Ivan Voras wrote:
> Sten Daniel Soersdal wrote:
>>
>> Does anyone know how to enable norwegian sorting rules for PostgreSQL
>> (8.2.4) on FreeBSD 6.x ?
>>
>> I've tried just about everything i can think of, but the extra three
>> letters just wont be sorted right.
>
> You'll probably need the ICU patch for PostgreSQL, which is
> unfortunately only available for 8.1.x - maybe you can bug the developer
> to provide it for newer versions of PostgreSQL.
>
Actually, i tried that and that didn't help at all.
Granted that was with UTF-8.
I came across an old open PR (51920) that adds Norwegian Collate
(ISO8859-1 + ISO8859-15) support to FreeBSD. Now my console and my
postgresql sorts correctly. I just hope someone would commit this
support to the tree.
The LATIN-1 / la_LN.ISO8859-1 collate is not right for norwegian alphabet.
http://www.freebsd.org/cgi/query-pr.cgi?pr=conf/51920--
Sten Daniel Soersdal
_______________________________________________
freebsd-database@... mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-databaseTo unsubscribe, send any mail to "
freebsd-database-unsubscribe@..."
signature.asc (257 bytes) 