Re: \COPY to accept non UTF-8 chars in CHAR columns

[Andrew Gierth <andrew@xxxxxxxxxxxxxxxxxxxx>]

>>>>> "Thomas" == Thomas Munro <thomas.munro@xxxxxxxxx> writes:

 Thomas> Something like this approach might be useful for fixing the CSV file:

 Thomas> https://codereview.stackexchange.com/questions/185821/convert-a-mix-of-latin-1-and-utf-8-to-proper-utf-8

Or:

perl -MEncode -pe '
 use bytes;
 sub c { decode("UTF-8",shift,sub { decode("windows-1252", chr(shift)) }); }
 s/([\x80-\xFF]+)/encode("UTF-8",c($1))/eg' <infile >outfile

-- 
Andrew (irc:RhodiumToad)