Postgres Pro
Downloads
Home   >   mailing lists

Re: [SPAM]-D] How to find broken UTF-8 characters ? - Mailing list pgsql-sql

From Jasen Betts
Subject Re: [SPAM]-D] How to find broken UTF-8 characters ?
Date
Msg-id hrebo0$cma$4@reversiblemaps.ath.cx
Whole thread Raw
In response to How to find broken UTF-8 characters ?  (Andreas <maps.on@gmx.net>)
List pgsql-sql
Tree view 
On 2010-04-29, Justin Graf <justin@magwerks.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 requestwas for LATIN-1 which does end at char(255))

pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: [SPAM]-D] How to find broken UTF-8 characters ?
Next
From: silly sad
Date:
Subject: LIMIT problem