UTF8 problem - Mailing list pgsql-novice

Hi all,

I have created a database using version 9.0 and set the client encoding to UTF* in the file postgresql.conf

Runnig the query:

INSERT INTO "JapaneseTest" ("ID", "name") Values(2, '\x83}\x83C \x83h\x83L\x83\x85\x83\x81\x83\x93\x83g (My Documents)')

Results in:

ERROR:  invalid byte sequence for encoding "UTF8": 0x83

********** Error **********

ERROR: invalid byte sequence for encoding "UTF8": 0x83

SQL state: 22021

I am running the query in pgAdmin III

My table looks like:

CREATE TABLE "JapaneseTest"

(

  "ID" bigint NOT NULL,

  "name" text,

  CONSTRAINT "JapaneseTest_pkey" PRIMARY KEY ("ID")

)

WITH (

  OIDS=FALSE

);

ALTER TABLE "JapaneseTest" OWNER TO postgres;

GRANT ALL ON TABLE "JapaneseTest" TO public;

GRANT ALL ON TABLE "JapaneseTest" TO postgres;

Can anyone help me?

Thanks, MeOtto