Re: CHARACTER SET problem

On Sat, 12 Sep 1998 23:08:44 GMT, Jurij Modic <jmodic_at_src.si> wrote:
>On Sat, 12 Sep 1998 00:40:41 GMT, joelga_at_pebble.org (Joel Garry)
>wrote:
>
>>On Tue, 8 Sep 1998 10:57:20 -0400, Al <al_at_work> wrote:
>>>You should also re-create any indexes that may contain non-standard
>>>characters (i.e. French accents). This will ensure that the values are in
>>>the correct order.
>>
>>Won't this be unnecessary unless NLS_SORT is set?
>
>Even then I belive recreating the indexes wouldn't be necessary, since
>keys in indexes are allways ordered in "binnary" mode and NLS
>parameters don't affect them.

And if you set NLS_SORT to anything besides binary, it does a full scan anyways with an order by. Default depends on NLS_LANGUAGE. <sigh>. Maybe someday this will make sense to me.

>
>Regards,
>--
>Jurij Modic <jmodic_at_src.si>
>Certified Oracle7 DBA (OCP)
>================================================
>The above opinions are mine and do not represent
>any official standpoints of my employer

jg

-- 
These opinions are my own and not necessarily those of Information Quest or 
Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com
http://ourworld.compuserve.com/homepages/joel_garry   Remove nospam to reply.  
mailto:joel_garry_at_compuserve.nospam.com  "See your DBA?"  I AM the @#%*& DBA!