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
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'
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2008-07-29 21:18:18|
|Subject: Re: BUG #4332: ERROR: invalid byte sequence for encoding "UTF8": 0xc3 |
|Previous:||From: Magnus Hagander||Date: 2008-07-29 13:41:11|
|Subject: Re: RES: BUG #4322: Problems with field not updatable|