UTF8 problem

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

Responses

Browse pgsql-novice by date

  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?