Re: regexp_replace and UTF8

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: regexp_replace and UTF8
Date: 2009-01-30 11:14:53
Message-ID: 87ljstm4eq.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be> writes:

> Hi,
> I have a text field with data like this: 'de pati&#235;nt niet'

> Can anyone help me fix this or point me to a better approach.
> By the way, changing the way data is put into the field is
> unfortunately not an option.
> Many thanks in advance.

You could use a plperl function to use one of the many html parsing perl
modules?

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Harald Fuchs 2009-01-30 15:47:04 Re: regexp_replace and UTF8
Previous Message Gerardo Herzig 2009-01-30 11:01:24 dynamic OUT parameters?