[EMAIL PROTECTED] writes: > 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'). Two likely theories: 1. Your database encoding is UTF-8, but your locale (LC_CTYPE) assumes some other encoding. 2. The encode() is yielding something that isn't valid UTF-8. PG 8.3 contains checks that should complain about both of these scenarios, but IIRC 8.2 does not. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly