Richard Huxton <dev@xxxxxxxxxxxx> writes: > Missed the mailing list on the last reply >> patrick wrote: >>> thoses queries are not working, same message: >>> ERROR: invalid byte sequence for encoding "UTF8": 0xc3 >>> >>> what i found is in postgresql.conf if i change: >>> default_text_search_config from pg_catalog.french to >>> pg_catalog.english then the query is working fine. I am just about convinced the problem is with french.stop. There is more to that error message than meets the eye: 0xc3 is a valid first byte for a two-byte UTF8 character, so the only way that the message would look just like that is if 0xc3 is the last byte in the presented string. Looking at french.stop, the only plausible place for this to happen is the line à (that's \303\240 or 0xc3 0xa0). I am thinking that something decided the \240 was junk and removed it. I wonder whether the dictionaries ought not be reading their data files in binary mode. They appear to all be using AllocateFile(filename, "r") which means that we're at the mercy of whatever text-mode conversion Windows feels like doing. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
