Mailing List Archive


Back to the month index Back to the list index
Joern Krueger (jkrueger@muenster.de)
Wed, 14 Apr 1999 18:04:44 +0200 

Message-ID: <3714BC9C.54D67935@muenster.de>
Date: Wed, 14 Apr 1999 18:04:44 +0200
From: Joern Krueger <jkrueger@muenster.de>
Subject: ORDER BY case insensitive?

Hello,

is it possible to toggle the ORDER BY statement to be
case insensitive?

Actually lower case letters are behind upper case letters
and I do not know how to change it. :-( 

-- 
Bye, Joern
From fmaior@upol.com.br  Wed Apr 14 12:50:06 1999
Received: from 200.245.11.130 (ppp-mta-01.montealto.net [200.245.11.130])
	by services.bunyip.com (8.8.5/8.8.5) with SMTP id MAA04133
	for <msql-list@services.bunyip.com>; Wed, 14 Apr 1999 12:50:04 -0400 (EDT)
Received: from upol.com.br
	([200.245.11.157])
	by 200.245.11.130; Wed, 14 Apr 1999 13:52:27 -0300
Message-ID: <3714AA1D.3E593B08@upol.com.br>
Date: Wed, 14 Apr 1999 11:45:49 -0300
From: Fernando Maior <fmaior@upol.com.br>
X-Mailer: Mozilla 4.51 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
To: jkrueger@muenster.de
CC: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: ORDER BY case insensitive?
References: <3714BC9C.54D67935@muenster.de>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Joern, Hi List,

I usually keep another column (or field) on the table that has all
characters converted to upper or lower case. Then, use ORDER BY on this
column instead of the other one. Also, I use Brazilian Portuguese as the
official language, as 100% of my users. This language has characters not
directly converted using upcase() or else. So, I have a function that
receives the string, converts it to ASCII-standard characters and to
upper case. Then, I can write it down to the database table.

It is too easy to work with Br-Portuguese language :-)

Bye,
Fernando Maior

Joern Krueger wrote:

> Hello,
>
> is it possible to toggle the ORDER BY statement to be
> case insensitive?
>
> Actually lower case letters are behind upper case letters
> and I do not know how to change it. :-(
>
> --
> Bye, Joern