Re: [SQL] psql encoding problem

2005-03-02 Thread T E Schmitz
Hello Ragnar, Ragnar Hafstað wrote: On Mon, 2005-02-28 at 20:48 +, T E Schmitz wrote: INSERT INTO item (name,retail_price) VALUES ('Cheese Soufflé',7.95,); psql comes back with "invalid byte sequence for encoding "UNICODE": 0xe9" might be the client encoding. set client_encoding='LATIN1'; so

Re: [SQL] psql encoding problem

2005-03-02 Thread Joel Fradkin
[SQL] 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&

Re: [SQL] psql encoding problem

2005-03-02 Thread Ragnar Hafstað
On Mon, 2005-02-28 at 20:48 +, T E Schmitz wrote: > 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

[SQL] psql encoding problem

2005-03-01 Thread T E Schmitz
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 in