[GENERAL] problems with copy

Hello I'm starting using PostgreSQL and want to import datas from my old database. I've made ASCII delimited files and want to use the copy instruction. Having the server started, I do the following : > psql mydb >copy table from 'myfile' using delimiters ';' ; I'vegot an error saying that the

[GENERAL] trouble with some characters

I'm using PostgreSQL 7.0.3 undr Mandrake and have the following problem : have columns with varchar or text in, some characters cannot be recognized, as è or à for examples. I got ) instead of è for example. How can I do to have them recognized ?? Thanks in advance Stephane -