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 or flat)
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

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-2014 The PostgreSQL Global Development Group