Re: COPY FROM on Windows and accentuated characters in the file path

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Thierry Hauchard <gesteam_l4d(at)gesteam(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY FROM on Windows and accentuated characters in the file path
Date: 2013-02-05 11:11:06
Message-ID: 20130205111106.GA17351@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 5, 2013 at 11:17:55AM +0100, Thierry Hauchard wrote:
> Hi,
>
> Using COPY FROM doesn't work if the path of the file has accentuated
> characters : command doesn't find the file.
> COPY FROM 'C:/import/prénoms/datas.txt' is so impossible.
>
> Is there a turnover ?
>
> PG 8.4, Windows XP

This must be a mismatch between your operating system encoding and your
database encoding.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra 2013-02-05 11:22:28 Re: COPY FROM on Windows and accentuated characters in the file path
Previous Message Hari Babu 2013-02-05 11:06:52 Re: Hot Standby has PANIC: WAL contains references to invalid pages