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

Hi,

Using COPY FROM doesn't work if the path of the file has accentuated=20
characters : command doesn't find the file.
COPY FROM 'C:/import/pr=E9noms/datas.txt' is so impossible.

Is there a turnover ?

PG 8.4, Windows XP

Thanks
Regards,
--
Thierry Hauchard

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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

On Tue, Feb 5, 2013 at 3:47 PM, Thierry Hauchard <gesteam_l4d@gesteam.fr>wr=
ote:

> 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=E9noms/datas.txt' is so impossible.
>
> Is there a turnover ?
>
> PG 8.4, Windows XP


Hmm...seems accent character not recognized by COPY command.

postgres=3D# copy users from 'c:/test/*=E5*test.txt';
ERROR:  could not open file "c:/test/+test.txt" for reading: No such file
or directory

I guess you should take help of batch script to remove ACCENT characters
and your COPY should be good to go.

Below link when I googled:
http://stackoverflow.com/questions/261515/batch-file-script-to-remove-speci=
al-characters-from-filenames-windows

Some other's might have better workarounds.

--Raghav