Thread: BUG #3986: Error ts_vector with UTF8 WS2003

The following bug has been logged online:

Bug reference:      3986
Logged by:          Yann
Email address:      yann.robin@withart.fr
PostgreSQL version: 8.3.0 build1400
Operating system:   Windows Server 2003
Description:        Error ts_vector with UTF8 WS2003
Details:

Hi,

When i try to execute the ts_vector function with a text i get the following
error :
ERROR: 22021: invalid byte sequence for encoding "UTF8": 0xc3

I've tried with a lot of different text, the error is always the same.

On a WINXP OS it works fine.

I've seen the same bug reported in your newsgroup :
 BUG #3766

Thanks,

--
Yann

Yann wrote:

> When i try to execute the ts_vector function with a text i get the following
> error :
> ERROR: 22021: invalid byte sequence for encoding "UTF8": 0xc3
>
It seems to be a client encoding problem. What is your client_encoding?
A common problem is a mismatch between client_encoding and the terminal
or application encoding.


--
   Euler Taveira de Oliveira
   http://www.timbira.com/

-----Message d'origine-----
>It seems to be a client encoding problem. What is your client_encoding?
>A common problem is a mismatch between client_encoding and the terminal
>or application encoding.

I've tried different encoding, I always get the same error.
As I said, I've got the same exact database on a windows XP and with the
same exact client, it works.

I found a workaround, when I use the to_tsvector function, I now specify the
configuration :

to_tsvector('test') => Error 22021
to_tsvector('simple', 'test') => OK

I think there a problem with the default behavior.

--
Yann