Re: BUG #1721: mutiple bytes character string comaprison error - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #1721: mutiple bytes character string comaprison error
Date
Msg-id 200506201852.j5KIqIN03093@candle.pha.pa.us
Whole thread Raw
In response to Re: BUG #1721: mutiple bytes character string comaprison error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #1721: mutiple bytes character string comaprison
List pgsql-bugs
Tom Lane wrote:
> Kris Jurka <books@ejurka.com> writes:
> > On Sun, 19 Jun 2005, Tom Lane wrote:
> >> Sorry, but UTF-8 encoding doesn't work properly on Windows (yet).
> >> Use some other database encoding.
>
> > Shouldn't we forbid its creation then?
>
> There was serious discussion of that before the 8.0 release, but
> we decided not to forbid it.  Check the archives; I don't recall
> the reasoning at the moment.

UTF8 encoding works with the C locale assuming you don't care about
ordering of the character set, e.g. Japanese.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-bugs by date:

Previous
From: "Dave Chapeskie"
Date:
Subject: BUG #1723: array_cat() bug when passed empty array
Next
From: "John Hansen"
Date:
Subject: Re: BUG #1721: mutiple bytes character string comaprison error