UTF8 problem
От | Kai Otto |
---|---|
Тема | UTF8 problem |
Дата | |
Msg-id | A2F2DADB84065C41B4948C619B5E482E021AA213@md-mail01.medis.local обсуждение исходный текст |
Ответы |
Re: UTF8 problem
|
Список | 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
В списке pgsql-novice по дате отправления: