Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: \COPY to accept non UTF-8 chars in CHAR columns
From: Andrew Gierth <andrew@xxxxxxxxxxxxxxxxxxxx>
Date: Fri, 27 Mar 2020 22:32:48 +0000
Cc: Thomas Munro <thomas.munro@xxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx>, Matthias Apitz <guru@xxxxxxxxxxx>, "pgsql-generallists.postgresql.org" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <20200327221835.GA27613@campbell-lange.net> (Rory Campbell-Lange's message of "Fri, 27 Mar 2020 22:18:35 +0000")
References: <20200327153623.GA32266@sh4-5.1blu.de> <8922.1585323994@sss.pgh.pa.us> <CA+hUKG+BAtBCXaB-0SYxNiVV3_CAbHvm7sm1PJWyhJFvTi_R3A@mail.gmail.com> <87k135a2hd.fsf@news-spur.riddles.org.uk> <20200327221835.GA27613@campbell-lange.net>
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (berkeley-unix)

>>>>> "Rory" == Rory Campbell-Lange <rory@xxxxxxxxxxxxxxxxxx> 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)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: \COPY to accept non UTF-8 chars in CHAR columns
  - From: Rory Campbell-Lange

References:
- \COPY to accept non UTF-8 chars in CHAR columns
  - From: Matthias Apitz
- Re: \COPY to accept non UTF-8 chars in CHAR columns
  - From: Tom Lane
- Re: \COPY to accept non UTF-8 chars in CHAR columns
  - From: Thomas Munro
- Re: \COPY to accept non UTF-8 chars in CHAR columns
  - From: Andrew Gierth
- Re: \COPY to accept non UTF-8 chars in CHAR columns
  - From: Rory Campbell-Lange

Prev by Date: Re: \COPY to accept non UTF-8 chars in CHAR columns
Next by Date: Re: \COPY to accept non UTF-8 chars in CHAR columns
Previous by thread: Re: \COPY to accept non UTF-8 chars in CHAR columns
Next by thread: Re: \COPY to accept non UTF-8 chars in CHAR columns
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]