Re: BUG #1721: mutiple bytes character string comaprison error

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kris Jurka <books(at)ejurka(dot)com>, Chii-Tung Liu <cdliou(at)mail(dot)cyut(dot)edu(dot)tw>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1721: mutiple bytes character string comaprison error
Date: 2005-06-20 18:52:18
Message-ID: 200506201852.j5KIqIN03093@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane wrote:
> Kris Jurka <books(at)ejurka(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John Hansen 2005-06-20 19:31:41 Re: BUG #1721: mutiple bytes character string comaprison error
Previous Message Dave Chapeskie 2005-06-20 16:07:37 BUG #1723: array_cat() bug when passed empty array