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