From: | "Kai Otto" <Kai(at)medis(dot)nl> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | UTF8 problem |
Date: | 2011-11-17 12:05:39 |
Message-ID: | A2F2DADB84065C41B4948C619B5E482E021AA213@md-mail01.medis.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Yves F. Barbier | 2011-11-17 14:31:22 | Re: UTF8 problem |
Previous Message | Yangyang | 2011-11-17 02:21:48 | How can I show more potential query plans, other than the default one? |