On Aug 23, 2004, at 7:47 PM, Tom Lane wrote:

>> 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.

Yes, my mail client changed the UTF-8 to EUC-KR (I'm going to find out 
how to make it send everything in UTF-8). But my examples were working 
as I described in the terminal with psql (and I do have my term set to 
use utf-8), and the problem was solved by initdb --locale=C.

And now that I know to just use C, I won't worry about it again.

Cheers,

David

In response to

• Re: UTF-8 and LIKE vs = at 2004-08-24 02:47:28 from Tom Lane

pgsql-general by date

Next:	From: Tom Lane	Date: 2004-08-24 04:02:49
	Subject: Re: Unsupported 3rd-party solutions (Was: Few questions
Previous:	From: Bruce Momjian	Date: 2004-08-24 03:37:33
	Subject: Re: Unsupported 3rd-party solutions (Was: Few questions