pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Eisentraut <peter_e@gmx.net>
To: Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: case sensitive/insensitive confusion
Date: Tue, 1 Feb 2005 11:14:00 +0100
Message-ID: <200502011114.00969.peter_e@gmx.net> (raw)
In-Reply-To: <41FF50CE.76CEB361@rodos.fzk.de>
References: <41FF50CE.76CEB361@rodos.fzk.de>

Christoph Haller wrote:
> It seems to me under hpux the sort is done case sensitive,
> as would one expect on SQL_ASCII encoding, whereas
> under linux a case insensitive sort is done.

The sort order depends entirely on the locale that you specify to initdb 
(not the encoding).  Please check the documentation there.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/



view thread (5+ messages)  latest in thread

Message-ID: <200502011114.00969.peter_e@gmx.net>
Permalink:  ../200502011114.00969.peter_e@gmx.net/
Also on:    postgresql.org/message-id/200502011114.00969.peter_e@gmx.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: peter_e@gmx.net, ch@rodos.fzk.de
  Subject: Re: case sensitive/insensitive confusion
  In-Reply-To: <200502011114.00969.peter_e@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox