http://pastebin.ca/845696 added schema ... On Jan 7, 10:21 pm, [EMAIL PROTECTED] 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, [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 5: don't forget to increase your free space map settings
