Re: how to config the sorting

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/03/23
Message-ID: <6f5j8k$c1n$5@news00.btx.dtag.de>#1/1

On 22 Mar 1998 18:13:39 GMT, "Loy&Hutz" <loyhutz_at_freiburg.netsurf.de> wrote: Hi,

try setting NLS_SORT in your INI<SID>.ORA or oracle.ini (win31) or registry (HKEY_LOACLMACHIN/SOFTWARE/ORACLE):

values:

	GERMAN
	GERMAN_DIN

they differ in sorting umlauts. GERMAN_DIN is the sorting that german telekom uses sorting the name in their phone-books.

>
>Is there a way to config the sorting of character fields ?
>
>or to get the order like ms access ?
>
>I migrate from access to oracle. Oracle puts empty fields at the end,
>access at the front of an result set. Oracle puts small letters after
>capitol letters, access vice versa.
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de

Received on Mon Mar 23 1998 - 00:00:00 CST