Import/export CSV files to postgres

Hi,

i'm importing and exporting CSV files to fill in tables on postgres 7.3.2
via PHP-4.2.2 (web interface)
The database uses UTF-8 encoding and MS-office uses ISO-8859-1.

When i import a CSV file to the DB, I execute the "recode" command to do the
ISO>UTF-8 conversion, after uploading it. Then the CSV is successfully
inserted in the DB.

The problem is on the export level:
the PHP script writes a CSV file to the disk. This file is UTF-8. It cannot
be read properly in excel. "Recode" in the oposite way (UTF-8>ISO) is
useless.

Does anyone know what I should do to be able to see the exported CSV in
MS-Excel correctly??

I would greatly  appreciate any suggestion.

Thanks in advance.
Regards
Nathalie




_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail