Re: Unexplained case insensitive results

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lloyd Mason" <LloydM(at)pbsinet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unexplained case insensitive results
Date: 2007-04-02 16:17:43
Message-ID: 10622.1175530663@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Lloyd Mason" <LloydM(at)pbsinet(dot)com> writes:
> There appears to be a difference in the results from the following SQL
> statement when run on an 8.1.5 version versus a 8.1.8 version:

I imagine you initdb'd the two installations with different locale
settings. Check "show lc_collate".

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anders Nilsson 2007-04-02 16:53:50 ECPG: inserting NULL values when using prepared statements
Previous Message David Brain 2007-04-02 15:58:25 Re: [GENERAL] Increasing the shared memory