Lists: | pgsql-general |
---|
From: | Howard Cole <howard(dot)cole(at)selestial(dot)com> |
---|---|
To: | 'PgSql General' <pgsql-general(at)postgresql(dot)org> |
Subject: | Case sensitivity |
Date: | 2005-06-10 12:22:16 |
Message-ID: | 42A985F8.4010503@selestial.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Has case sensitivity changed between 8.0.1 and 8.0.3 or am I missing
some setting somewhere?
I try the following sql on two database servers and get different results:
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?
regards
Howard Cole
www.selestial.com
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Howard Cole <howard(dot)cole(at)selestial(dot)com> |
Cc: | "'PgSql General'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Case sensitivity |
Date: | 2005-06-12 18:49:55 |
Message-ID: | 26677.1118602195@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Howard Cole <howard(dot)cole(at)selestial(dot)com> writes:
> Has case sensitivity changed between 8.0.1 and 8.0.3
Nope.
> Results on 8.0.3 windows server (UNICODE)
Unicode doesn't work at all well on Windows. Consider using a different
encoding. Also, you'd better check that you have matching locale and
encoding settings on both those installations ...
regards, tom lane
From: | Howard Cole <howardnews(at)selestial(dot)com> |
---|---|
To: | 'PgSql General' <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Case sensitivity |
Date: | 2005-06-13 08:32:18 |
Message-ID: | 42AD4492.9060008@selestial.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
I looked into the problem further - and could not repeat the problem on
my windows XP machine. The problem was isolated to a server which uses
the 64bit edition of W2K3 server. Otherwise the W2K3 64bit edition seems
to run PG ok.
Are there any plans for fixing the UNICODE encoding on Windows?
Regards,
Howard Cole
www.selestial.com