Re: Collating sequence question?

On Thu, 7 Aug 2003 15:29:19 +0000 (UTC), Hemant Shah <shah_at_typhoon.xnet.com> wrote:

>
>Folks,
>
> Can I setup Oracle server/database so that it does not use any collating
> sequence (i.e. do a byte by byte comparisions)?

The NLS_SORT parameter can be set to the value BINARY:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch4.htm#1004875

Haven't had hands-on experience to know how pervasive the results are. I see ORDER BY clauses explicitly calling the NLSSORT function when they want to ensure a particular linguistic order:

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96540/functions82a.htm#84558

John

--
Photo gallery: http://www.pbase.com/john_russell/