BUG #4253: to_tsvector: error with some configurations - Mailing list pgsql-bugs

From Giorgio Valoti
Subject BUG #4253: to_tsvector: error with some configurations
Date
Msg-id 200806181237.m5ICbHH2055080@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4253: to_tsvector: error with some configurations  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4253
Logged by:          Giorgio Valoti
Email address:      giorgio_v@mac.com
PostgreSQL version: 8.3.3
Operating system:   Mac OS X 10.5.3
Description:        to_tsvector: error with some configurations
Details:

Using every language containing the "a grave" letter (c3 a0) causes an error
when the function "ts_vector" is invoked.

test=> select to_tsvector('italian','prova');
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".

test=> select to_tsvector('french','prova');
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".

test=> select to_tsvector('portuguese','prova');
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".

pgsql-bugs by date:

Previous
From: "Andreas Andersson"
Date:
Subject: BUG #4252: SQL stops my graic cards
Next
From: Bill Moran
Date:
Subject: Re: BUG #4252: SQL stops my graic cards