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

Re: BUG #4253: to_tsvector: error with some configurations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Giorgio Valoti" <giorgio_v(at)mac(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4253: to_tsvector: error with some configurations
Date: 2008-06-18 15:16:48
Message-ID: 27306.1213802208@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Giorgio Valoti" <giorgio_v(at)mac(dot)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

In response to

pgsql-bugs by date

Next:From: GlennDate: 2008-06-18 16:22:29
Subject: BUG #4254: wont let me install it says account name already used or somthing
Previous:From: Alvaro HerreraDate: 2008-06-18 14:15:59
Subject: Re: BUG #4252: SQL stops my graic cards

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