Re: UTF-8 and LIKE vs = - Mailing list pgsql-general

From Tom Lane
Subject Re: UTF-8 and LIKE vs =
Date
Msg-id 27102.1093315648@sss.pgh.pa.us
Whole thread Raw
In response to Re: UTF-8 and LIKE vs =  (David Wheeler <david@kineticode.com>)
Responses Re: UTF-8 and LIKE vs =  (David Wheeler <david@kineticode.com>)
List pgsql-general
David Wheeler <david@kineticode.com> writes:
>>> Hmm.  I tried putting your string into a UNICODE database and I got
>>> ERROR:  invalid byte sequence for encoding "UNICODE": 0xc7
>>
>> Really? Curious.

> Oh, are you sure that you got my UTF-8 data? Because it came back in
> your reply all mangled.

I deliberately left it half-MIME-ified so that the hex byte values would
be visible.  One of the variables we have not controlled for is whether
what you posted is the same as what other people received --- Tim
Allen's point about the claimed encoding of the message is very relevant
here.  Lots of mail software will try to translate encodings.

            regards, tom lane

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions
Next
From: Thomas Hallgren
Date:
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions