Re: [HACKERS] Windows and locales and UTF-8 (oh my)

2007-10-17 Thread Euler Taveira de Oliveira
Magnus Hagander wrote: Got some help on IRC to dentify the charafters as ç and Ç. Exact. I can confirm that both work perfectly fine with UTF-8 and locale Swedish_Sweden.1252. They sort correctly, and they work with both upper() and lower() correctly. I didn't remember what locale is.

Re: [HACKERS] Windows and locales and UTF-8 (oh my)

2007-10-16 Thread Magnus Hagander
On Mon, Oct 15, 2007 at 07:44:00PM +0200, Magnus Hagander wrote: Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: Tom Lane wrote: Hmm. If it doesn't need a special case, then we still lack an explanation for the aforementioned bug report. From what I can tell that report

Re: [HACKERS] Windows and locales and UTF-8 (oh my)

2007-10-15 Thread Magnus Hagander
On Sat, Oct 06, 2007 at 01:53:31PM -0400, Tom Lane wrote: I've been learning much more than I wanted to know about $SUBJECT since putting in the src/port/chklocale.c code to try to enforce that our database encoding matches the system locale settings. There's an ongoing thread in -patches

Re: [HACKERS] Windows and locales and UTF-8 (oh my)

2007-10-15 Thread Magnus Hagander
On Mon, Oct 15, 2007 at 11:09:54AM +0200, Magnus Hagander wrote: On Sat, Oct 06, 2007 at 01:53:31PM -0400, Tom Lane wrote: I am thinking that Dave's discovery explains some previously unsolved bug reports, such as http://archives.postgresql.org/pgsql-bugs/2007-05/msg00260.php If Windows

Re: [HACKERS] Windows and locales and UTF-8 (oh my)

2007-10-15 Thread Magnus Hagander
On Mon, Oct 15, 2007 at 01:26:00PM +0200, Magnus Hagander wrote: On Mon, Oct 15, 2007 at 11:09:54AM +0200, Magnus Hagander wrote: On Sat, Oct 06, 2007 at 01:53:31PM -0400, Tom Lane wrote: I am thinking that Dave's discovery explains some previously unsolved bug reports, such as

Re: [HACKERS] Windows and locales and UTF-8 (oh my)

2007-10-15 Thread Tom Lane
Magnus Hagander [EMAIL PROTECTED] writes: On Sat, Oct 06, 2007 at 01:53:31PM -0400, Tom Lane wrote: I am thinking that Dave's discovery explains some previously unsolved bug reports, such as http://archives.postgresql.org/pgsql-bugs/2007-05/msg00260.php ... And given that, do we even nede to

Re: [HACKERS] Windows and locales and UTF-8 (oh my)

2007-10-15 Thread Magnus Hagander
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: On Sat, Oct 06, 2007 at 01:53:31PM -0400, Tom Lane wrote: I am thinking that Dave's discovery explains some previously unsolved bug reports, such as http://archives.postgresql.org/pgsql-bugs/2007-05/msg00260.php ... And given that,

Re: [HACKERS] Windows and locales and UTF-8 (oh my)

2007-10-15 Thread Tom Lane
Magnus Hagander [EMAIL PROTECTED] writes: Tom Lane wrote: Hmm. If it doesn't need a special case, then we still lack an explanation for the aforementioned bug report. From what I can tell that report doesn't tell us very much - we don't know server encoding, we don't know server locale, we

Re: [HACKERS] Windows and locales and UTF-8 (oh my)

2007-10-15 Thread Magnus Hagander
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: Tom Lane wrote: Hmm. If it doesn't need a special case, then we still lack an explanation for the aforementioned bug report. From what I can tell that report doesn't tell us very much - we don't know server encoding, we don't know

[HACKERS] Windows and locales and UTF-8 (oh my)

2007-10-06 Thread Tom Lane
I've been learning much more than I wanted to know about $SUBJECT since putting in the src/port/chklocale.c code to try to enforce that our database encoding matches the system locale settings. There's an ongoing thread in -patches that's been focused on getting reasonable behavior from the point