Re: Case sensitivity - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Case sensitivity
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE094517@algol.sollentuna.se
Whole thread Raw
In response to Case sensitivity  (Howard Cole <howard.cole@selestial.com>)
List pgsql-general
> create table test (val varchar(10));
> insert into test values ('A');
> insert into test values ('a');
> select * from test where val < 'a';
>
> Results on 8.0.1 linux server (UNICODE)
>  val
> -----
> (0 rows)
>
> Results on 8.0.3 windows server (UNICODE)  val
> -----
>  A
> (1 row)
>
> I am guessing that the 8.0.3 on windows is the correct
> version - but what changes this and how can I set it?

UNICODE is not currently supported on win32. We hope to have this done
in 8.1, but in 8.0 bad things like this will happen. See
http://www.postgresql.org/docs/faqs.FAQ_windows.html#2.6.

//Magnus

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Trying to get posgreSQL-8.0.3 up on Tiger 10.4.1
Next
From: Tom Lane
Date:
Subject: Re: Use of Indexes