RE: nls_sort

>From: GKor_at_rdw.nl
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Mon, 29 Sep 2003 03:04:40
>
>hi all
>
>we had a strange sort order on a attribute in a
>table with dashes (-) in the
>data.
>
>example
>
>query with default NLS_SORT (NLS_LANGUAGE=american)
>
>
>R/10-02
>R/1-01
>R/101-00
>R/101-03
>
>query with NLS_SORT=BINARY
>
>R/1-01
>R/10-02
>R/101-00
>R/101-03
>
>Anyone with an explanation why this parameter is
>not default BINARY ?
>
>
>thanks
>
>vr.gr.
>G. Kor
>Sr. System Engineer I&DM Db
>RDW Voertuiginformatie en -toelating
>Ict Bedrijf
>

EBCDIC ? Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).