Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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!Received on Thu Sep 17 1998 - 00:00:00 CDT