That does indeed appear to be the case -- the database on the Linux server
has en_CA.UTF-8 collation, while the database on the Windows server has
English_Canada.1252 collation. Thanks!
Doug
On Wed, Apr 27, 2011 at 1:04 PM, Thom Brown wrote:
> On 27 April 2011 20:28, Doug Gorley wrote:
>
>>
On 27 April 2011 20:28, Doug Gorley wrote:
> I'm running the following SQL commands on a new PostgreSQL 9.0 database,
> one on Linux, one on Windows.
>
> create table i (j varchar(4));
> insert into i (j) values ('A'), ('E'), (' select j from i order by j asc;
>
> On the Windows server I get the
I'm running the following SQL commands on a new PostgreSQL 9.0 database, one
on Linux, one on Windows.
create table i (j varchar(4));
insert into i (j) values ('A'), ('E'), ('