psql encoding problem

Hello,

I am trying to insert the following record:

INSERT INTO item (name,retail_price) VALUES ('Cheese Soufflé',7.95,);

(I presume you see the accented character in *Soufflé*)

psql comes back with "invalid byte sequence for encoding "UNICODE": 0xe9"
If I do this via DbVisualizer, the record is inserted fine.

Is there any way around this problem?

--

Regards/Gruß,

Tarlika Elisabeth Schmitz