Re: [SPAM]-D] How to find broken UTF-8 characters ?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SPAM]-D] How to find broken UTF-8 characters ?
Date: 2010-04-30 10:34:40
Message-ID: hrebo0$cma$4@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2010-04-29, Justin Graf <justin(at)magwerks(dot)com> wrote:

> I'm pretty sure this is the regualr expression to find all non ASCII=20
> chars.. [^\x00-\xFF]

Not in postgres.

\x00 does not work well in strings, and \xFF is invalid utf-8.
this is why I used char()

(also ASCII is undefined past at \x7F ... but the original request
was for LATIN-1 which does end at char(255))

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message silly sad 2010-04-30 12:50:18 LIMIT problem
Previous Message Jasen Betts 2010-04-30 10:21:03 Re: [SPAM]-D] How to find broken UTF-8 characters ?