finding bogus UTF-8

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: finding bogus UTF-8
Date: 2011-02-10 19:02:15
Message-ID: 573022F5-66FD-4537-B3D8-086A571A1ECE@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I know that I have at least one instance of a varchar that is not valid UTF-8, imported from a source with errors (AMA CPT files, actually) before PG's checking was as stringent as it is today. Can anybody suggest a query to find such values?

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2011-02-10 19:43:43 Re: COPY statement REAL vs VARCHAR precision issue
Previous Message Joshua D. Drake 2011-02-10 18:54:42 Cross Pollination is a wonderful thing