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
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 |
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 |