Postgres Pro
Downloads
Home   >   mailing lists

Re: \COPY to accept non UTF-8 chars in CHAR columns - Mailing list pgsql-general

From Andrew Gierth
Subject Re: \COPY to accept non UTF-8 chars in CHAR columns
Date
Msg-id 87ftdta0qs.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: \COPY to accept non UTF-8 chars in CHAR columns  (Rory Campbell-Lange <rory@campbell-lange.net>)
Responses Re: \COPY to accept non UTF-8 chars in CHAR columns  (Rory Campbell-Lange <rory@campbell-lange.net>)
List pgsql-general
Tree view 
>>>>> "Rory" == Rory Campbell-Lange <rory@campbell-lange.net> writes:

 Rory> Or:

 Rory>     iconv -f WINDOWS-1252 -t UTF-8 -c < tempfile2 > tempfile3

No. That's just a conversion of win1252 to utf8 without regard for any
UTF8 that might already be present in the input. Any such input will end
up double-encoded, requiring further work to fix.

-- 
Andrew (irc:RhodiumToad)

pgsql-general by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: \COPY to accept non UTF-8 chars in CHAR columns
Next
From: Rory Campbell-Lange
Date:
Subject: Re: \COPY to accept non UTF-8 chars in CHAR columns