tsearch2 in postgresql 8.3.1 - invalid byte sequence for encoding "UTF8": 0xc3

From: "patrick" <patrick(at)11h11(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: tsearch2 in postgresql 8.3.1 - invalid byte sequence for encoding "UTF8": 0xc3
Date: 2008-03-19 01:27:23
Message-ID: 01e601c88960$62340060$0d02a8c0@audio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

hi,

i have an issue with tseach2, i just installed postgresql 8.3.1 on windows
using UTF8 server encoding / client encoding and LOCALE Canada / French.

CREATE DATABASE mydbWITH OWNER = me ENCODING = 'UTF8';
CREATE TABLE product
(
product_id SERIAL NOT NULL,
name VARCHAR(50) NOT NULL,
description VARCHAR(1000) NOT NULL,
CONSTRAINT pk_product PRIMARY KEY (product_id)
);
ALTER TABLE product ADD COLUMN search_vector tsvector;
CREATE INDEX idx_search_vector ON product USING gist(search_vector);

UPDATE product SET search_vector = setweight(to_tsvector(name), 'A') ||
to_tsvector(description);

ERROR: invalid byte sequence for encoding "UTF8": 0xc3
SQL state: 22021
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".

any idea why it's happening?
pat

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tyler, Mark 2008-03-19 01:35:54 Re: Problem with async notifications of table updates
Previous Message Tyler, Mark 2008-03-19 01:07:16 Re: Problem with async notifications of table updates

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-03-19 01:28:50 Re: [COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that
Previous Message Tatsuo Ishii 2008-03-19 00:42:08 Re: Proposal: new large object API