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

From Tom Lane
Subject Re: BUG #4253: to_tsvector: error with some configurations
Date
Msg-id 27306.1213802208@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4253: to_tsvector: error with some configurations  ("Giorgio Valoti" <giorgio_v@mac.com>)
List pgsql-bugs
"Giorgio Valoti" <giorgio_v@mac.com> writes:
> 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

Hmm, works for me:

z=# select to_tsvector('italian','prova');
 to_tsvector
-------------
 'prov':1
(1 row)

What database encoding (server_encoding) are you using?  Is it possible
that the text search configuration files have been rewritten into a
non-UTF8 encoding?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #4252: SQL stops my graic cards
Next
From: "Glenn"
Date:
Subject: BUG #4254: wont let me install it says account name already used or somthing