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 before the 8.0

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 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 //Magnus

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 discussion of that before

[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

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

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 work properly on

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 decided not

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: When