Re: Proof of concept COLLATE support with patch

On Mon, Sep 05, 2005 at 01:52:45AM +0200, Petr Jelinek wrote:
> Tom Lane wrote:
> >
> >The hole in that argument is the assumption that there *is* a freely
> >available library that can be used (where freely == BSD license).
> >We wouldn't be having this discussion if we knew of one.
> 
> I see this discussion as another reason to use ICU, I mean complete 
> rewrite of locale handling to use ICU on all platforms. I know it's big 
> project but it's doable for 8.2 and it would virtually solve all locale 
> problems and could be base for new unicode/locale features. I am not 
> sure if this is the way postgres wants to go tho (having dependency on 
> such a big and uncommon library).

Maybe not so uncommon...

% ldd /usr/local/bin/php
/usr/local/bin/php:
...       -lresolv.1 => /usr/lib/libresolv.so.1       -lpq.4 => /usr/local/pgsql/lib/libpq.so.4       -lintl.0 =>
/usr/lib/libintl.so.0      -licudata.34 => /usr/local/lib/libicudata.so.34       -licuuc.34 =>
/usr/local/lib/libicuuc.so.34      -licui18n.34 => /usr/local/lib/libicui18n.so.34       -licuio.34 =>
/usr/local/lib/libicuio.so.34
...

Cheers,

Patrick