Unicode normalization - Mailing list pgsql-general

From Andreas Kalsch
Subject Unicode normalization
Date
Msg-id 4AB11E55.2020207@gmx.de
Whole thread Raw
Responses Re: Unicode normalization  (David Fetter <david@fetter.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: I need a Postgres Admin $130K + 20K in NYC Any Ideas?
Next
From: Raymond O'Donnell
Date:
Subject: Re: pgadmin is changing pgpass.conf