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

BUG #4253: to_tsvector: error with some configurations

From: "Giorgio Valoti" <giorgio_v(at)mac(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4253: to_tsvector: error with some configurations
Date: 2008-06-18 12:37:17
Message-ID: 200806181237.m5ICbHH2055080@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4253
Logged by:          Giorgio Valoti
Email address:      giorgio_v(at)mac(dot)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".

Responses

pgsql-bugs by date

Next:From: Bill MoranDate: 2008-06-18 13:06:46
Subject: Re: BUG #4252: SQL stops my graic cards
Previous:From: Andreas AnderssonDate: 2008-06-18 01:07:37
Subject: BUG #4252: SQL stops my graic cards

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