Re: ERROR: translation failed from server encoding to wchar_t

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...@gmail.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