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

Re: ERROR: translation failed from server encoding to wchar_t

From: ilanco(at)gmail(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ERROR: translation failed from server encoding to wchar_t
Date: 2008-01-07 20:33:32
Message-ID: 2c640d82-edcd-4c64-a72d-f41f0fb48cca@u10g2000prn.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-hackers
http://pastebin.ca/845696
added schema ...
On Jan 7, 10:21 pm, ila(dot)(dot)(dot)(at)gmail(dot)com wrote:
> http://pastebin.ca/845670
>
> This url provides a testcase ...
>
> fisrt pass :
> => UPDATE dbmail_messageblks SET idxFTI=to_tsvector('simple',
> encode(messageblk, 'escape')) where messageblk_idnr = 12949;
> ERROR:  translation failed from server encoding to wchar_t
>
> second pass :
> => UPDATE dbmail_messageblks SET idxFTI=to_tsvector('simple',
> encode(messageblk, 'escape')) where messageblk_idnr = 12949;
> UPDATE 1
>
> The to_tsvector seems to accept the row at random ...
>
> On Jan 7, 9:16 pm, ila(dot)(dot)(dot)(at)gmail(dot)com wrote:
>
> > I am using tsearch2 with pgsql 8.2.5 and get the following error when
> > calling to_tsvector :
> > "translation failed from server encoding to wchar_t"
>
> > My database is UTF8 encoded and the data sent to to_tsvector comes
> > from a bytea column converted to text with
> > encode(COLUMN, 'escape').
>
> > In 8.1 with tsearch2 it worked perfectly ...
>
> > Thanks for you help,
>
> > ilan


In response to

pgsql-hackers by date

Next:From: Ron MayerDate: 2008-01-07 20:53:31
Subject: Re: Dynamic Partitioning using Segment Visibility Maps
Previous:From: Tom LaneDate: 2008-01-07 20:31:15
Subject: Re: Bug: Unreferenced temp tables disables vacuum to update xid

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