Thread: BUG #3604: lo_import does not work with filenames with accents

BUG #3604: lo_import does not work with filenames with accents

From
"Pascal Van De Gucht"
Date:
The following bug has been logged online:

Bug reference:      3604
Logged by:          Pascal Van De Gucht
Email address:      pascal@1direction.com
PostgreSQL version: 8.2
Operating system:   Windows 2003
Description:        lo_import does not work with filenames with accents
Details:

When I use the lo_import function to insert a file in a database, it doesn't
work with files with a file name containing accents.
Then I get this error:
could not open server file "\\WORKDIRS\TEST\Lead Delvaux AM Comptabilité
Fiscalité.pdf": No such file or directory.

Is there a solution?

Re: BUG #3604: lo_import does not work with filenames with accents

From
"Hiroshi Saito"
Date:
Hi.

I think that the problem's clarifying path and encoding need to be directed.
Please see,
http://winpg.jp/~saito/pg_work/LageObject_psql.png
Sorry it is japanese:-)

Regards,
Hiroshi Saito

----- Original Message -----
From: "Pascal Van De Gucht" <pascal@1direction.com>


>
> The following bug has been logged online:
>
> Bug reference:      3604
> Logged by:          Pascal Van De Gucht
> Email address:      pascal@1direction.com
> PostgreSQL version: 8.2
> Operating system:   Windows 2003
> Description:        lo_import does not work with filenames with accents
> Details:
>
> When I use the lo_import function to insert a file in a database, it doesn't
> work with files with a file name containing accents.
> Then I get this error:
> could not open server file "\\WORKDIRS\TEST\Lead Delvaux AM Comptabilit??
> Fiscalit??.pdf": No such file or directory.
>
> Is there a solution?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings