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

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: [SPAM]-D] How to find broken UTF-8 characters ?
Дата
Msg-id hrebo0$cma$4@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на How to find broken UTF-8 characters ?  (Andreas <maps.on@gmx.net>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: [SPAM]-D] How to find broken UTF-8 characters ?
Следующее
От: silly sad
Дата:
Сообщение: LIMIT problem