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, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate