On Tuesday 14 July 2009 15:52:29 Alvaro Herrera wrote: > Andres Freund wrote: > > On Tuesday 14 July 2009 11:36:57 Jasen Betts wrote: > > > if you do an ascii dump and the dump starts out "SET CLIENT ENCODING > > > 'UTF8'" or similar but you still get errors. > > > > Do you mean that a dump from SQL_ASCII can yield non-utf8 data? right. > > But According to the OP his 8.3 database is UTF8... > > So there should not be invalid data in there. > I haven't followed this thread, but older PG versions had less strict > checks on UTF8 data, which meant that some invalid data could creep in. But that was from 8.2 -> 8.3 and not 8.3->8.4 I think? Andres -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
