Re: [GENERAL] Different sort order btwn Linux and Windows

2011-04-27 Thread Doug Gorley
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: > >>

Re: [GENERAL] Different sort order btwn Linux and Windows

2011-04-27 Thread Thom Brown
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

[GENERAL] Different sort order btwn Linux and Windows

2011-04-27 Thread Doug Gorley
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'), ('