patrick wrote:
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.
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".
Can you identify which row(s) are causing this problem? If we have the
value that's causing this, someone can reproduce it.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
