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:21:15 |
Message-ID: | 4d194037-2bcd-4c6f-8d49-1dc3cac4e602@c23g2000hsa.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | ilanco | 2008-01-07 20:27:02 | Re: ERROR: translation failed from server encoding to wchar_t |
Previous Message | Hannes Dorbath | 2008-01-07 19:46:01 | Re: Index trouble with 8.3b4 |