Home > mailing lists

finding bogus UTF-8 - Mailing list pgsql-general

From	Scott Ribe
Subject	finding bogus UTF-8
Date	February 10, 2011 15:09:08
Msg-id	573022F5-66FD-4537-B3D8-086A571A1ECE@elevated-dev.com Whole thread Raw
Responses	Re: finding bogus UTF-8 Re: finding bogus UTF-8 Re: finding bogus UTF-8 Re: finding bogus UTF-8
List	pgsql-general

Tree view

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
CPTfiles, 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@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

pgsql-general by date:

From: "Joshua D. Drake"
Date: 10 February 2011, 14:55:22
Subject: Cross Pollination is a wonderful thing

From: Raymond O'Donnell
Date: 10 February 2011, 15:43:55
Subject: Re: COPY statement REAL vs VARCHAR precision issue

finding bogus UTF-8 - Mailing list pgsql-general

Previous

Next