Re: CHARACTER SET problem

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.

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