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

>>>>> "Thomas" == Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 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)