Re: [BUGS] BUG #1721: mutiple bytes character string comaprison

2005-06-20 Thread Tatsuo Ishii
> Tom Lane wrote: > > Kris Jurka <[EMAIL PROTECTED]> 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 disc

Re: [BUGS] BUG #1721: mutiple bytes character string comaprison error

2005-06-20 Thread Magnus Hagander
> > UTF8 encoding works with the C locale assuming you don't care about > > ordering of the character set, e.g. Japanese. > > > > Has anyone with the ability to compile postgresql on windows > tested the ICU patch? Yes. See http://archives.postgresql.org/pgsql-hackers/2005-05/msg00662.php //

Re: [BUGS] BUG #1721: mutiple bytes character string comaprison error

2005-06-20 Thread John Hansen
> > UTF8 encoding works with the C locale assuming you don't care > about ordering of the character set, e.g. Japanese. > Has anyone with the ability to compile postgresql on windows tested the ICU patch? ... John ---(end of broadcast)--- TIP 5:

Re: [BUGS] BUG #1721: mutiple bytes character string comaprison error

2005-06-20 Thread Bruce Momjian
Tom Lane wrote: > Kris Jurka <[EMAIL PROTECTED]> 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 bef

Re: [BUGS] BUG #1721: mutiple bytes character string comaprison

2005-06-19 Thread Tatsuo Ishii
> The following bug has been logged online: > > Bug reference: 1721 > Logged by: Chii-Tung Liu > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.3 > Operating system: Windows XP SP2 > Description:mutiple bytes character string comaprison error > Details: >

Re: [BUGS] BUG #1721: mutiple bytes character string comaprison error

2005-06-19 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> 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 deci

Re: [BUGS] BUG #1721: mutiple bytes character string comaprison

2005-06-19 Thread Kris Jurka
On Sun, 19 Jun 2005, Tom Lane wrote: > "Chii-Tung Liu" <[EMAIL PROTECTED]> writes: > > PostgreSQL version: 8.0.3 > > Operating system: Windows XP SP2 > > > When compare two UTF-8 encoded string that contains Chinese words, the > > result is always TRUE > > Sorry, but UTF-8 encoding doesn't w

Re: [BUGS] BUG #1721: mutiple bytes character string comaprison error

2005-06-19 Thread Tom Lane
"Chii-Tung Liu" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 8.0.3 > Operating system: Windows XP SP2 > When compare two UTF-8 encoded string that contains Chinese words, the > result is always TRUE Sorry, but UTF-8 encoding doesn't work properly on Windows (yet). Use some other database e

[BUGS] BUG #1721: mutiple bytes character string comaprison error

2005-06-19 Thread Chii-Tung Liu
The following bug has been logged online: Bug reference: 1721 Logged by: Chii-Tung Liu Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows XP SP2 Description:mutiple bytes character string comaprison error Details: When compare two U