Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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")





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 by date

Next:From: Jean-Yves F. BarbierDate: 2011-11-17 14:31:22
Subject: Re: UTF8 problem
Previous:From: YangyangDate: 2011-11-17 02:21:48
Subject: How can I show more potential query plans, other than the default one?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group