Re: Unicode normalization - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Unicode normalization
Date
Msg-id 20090917040157.GI13076@alvh.no-ip.org
Whole thread Raw
In response to Re: Unicode normalization  (Andreas Kalsch <andreaskalsch@gmx.de>)
Responses Re: Unicode normalization
Re: Unicode normalization
List pgsql-general
Andreas Kalsch wrote:

> 2) Transfering this to PL/Python:
>
> CREATE OR REPLACE FUNCTION test (str text)
>  RETURNS text
> AS $$
>    import unicodedata
>    return unicodedata.normalize('NFKD', str.decode('UTF-8'))
> $$ LANGUAGE plpythonu;

This is wrong, which is why we published a correct version here:

http://wiki.postgresql.org/wiki/Strip_accents_from_strings

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: wrong error from ./configure in pgsql 8.3.8 for libxml
Next
From: Sulman Sarwar
Date:
Subject: Re: Segmentation Fault during database restoration