Re: Unicode normalization

On Wed, Sep 16, 2009 at 07:20:21PM +0200, Andreas Kalsch wrote:
> Has somebody integrated Unicode normalization into Postgres? if not, I
> would have to implement my own function by using this CPAN module:
> http://search.cpan.org/~sadahiro/Unicode-Normalize-1.03/ .
>
> I need a function which removes all diacritics (1) and transforms some
> characters to a more compatible form (2) to get a better index on
> strings.
>
> Best,
>
> Andi
>
>
> 1) à,ä, ... => a
> 2) ø => o, ƒ => f, ª => a

You mean something like this?

http://wiki.postgresql.org/wiki/Strip_accents_from_strings%2C_and_output_in_lowercase

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate