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

BUG #4332: ERROR: invalid byte sequence for encoding "UTF8": 0xc3

From: "Maxime Carbonneau" <manitou(at)maikan(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4332: ERROR: invalid byte sequence for encoding "UTF8": 0xc3
Date: 2008-07-29 20:15:16
Message-ID: 200807292015.m6TKFGLT045483@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4332
Logged by:          Maxime Carbonneau
Email address:      manitou(at)maikan(dot)com
PostgreSQL version: 8.3.3
Operating system:   Mac OS X 10.5.4
Description:        ERROR:  invalid byte sequence for encoding "UTF8": 0xc3
Details: 

Doing "SELECT to_tsvector('pg_catalog.french', 'ecole');" in the psql
console, I get 
ERROR:  invalid byte sequence for encoding "UTF8": 0xc3
HINT:  This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
I did some modification on the file
"/usr/local/pgsql/share/tsearch_data/french.stop" to realize that the letter
'à' brings the error.
SHOW client_encoding; => 'UTF8'

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-07-29 21:18:18
Subject: Re: BUG #4332: ERROR: invalid byte sequence for encoding "UTF8": 0xc3
Previous:From: Magnus HaganderDate: 2008-07-29 13:41:11
Subject: Re: RES: BUG #4322: Problems with field not updatable

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