On Wed, Jan 13, 2010 at 04:15:06PM +0100, Martin Flahault wrote: [postgres] > newbase=# select * from t1 order by contenu; > contenu > --------- > A > E > a > e
Postgresql outputs whatever the C library does on the underlying system. The quality of this varies wildly. > à > As with others DBMS (MySQL for example), diacritics should be ignored when > determining the sort order. Here is the expected output: MySQL implements the unicode collation algorithm, which means it essentially does what you want. > > It seems there is a problem with the collating order on BSD systems with > diacritics using UTF8. Last I checked, BSD did not support useful sorting on UTF-8 at all, so it's not surprised it doesn't work. > in a UTF8 text file and use the "sort" command on it, you will have the same > wrong output as with PostgreSQL : Yes, that's the basic idea. Mac OS X apparently provides ICU underneath for programs that would like true unicode collation, but there is little chance that postgresql will ever use this. Hope this helps, -- Martijn van Oosterhout <klep...@svana.org> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature