Re: Differences in UTF8 between 8.0 and 8.1 - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Differences in UTF8 between 8.0 and 8.1
Date
Msg-id 435C6BBA.4070004@familyhealth.com.au
Whole thread Raw
In response to Re: Differences in UTF8 between 8.0 and 8.1  (Paul Lindner <lindner@inuus.com>)
List pgsql-hackers
> Thanks go out to John Hansen, he recommended to run the dump through iconv:
> 
>   iconv -c -f UTF8 -t UTF8 -o fixed.sql dump.sql
> 
> This seems to strip out invalid UTF8 and will allow for a clean
> import.  Someone should add this to the Release Notes/FAQ..

Yes I think that's extremely important to put in the 'upgrading/back 
compatibiliy' section for these release notes.

Chris



pgsql-hackers by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance
Next
From: Andrew - Supernews
Date:
Subject: Re: Differences in UTF8 between 8.0 and 8.1