Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> [ORA 8.1.7 AIX] Setting NLS_COMP to ANSI

[ORA 8.1.7 AIX] Setting NLS_COMP to ANSI

From: Alain <awahani_at_nospam.yahoo.fr>
Date: Wed, 28 Nov 2001 09:30:07 +0100
Message-ID: <3C04A08F.E2AE0241@nospam.yahoo.fr> 





Hello,



We're about to set NLS_COMP to ANSI in order to avoid using the NLSSORT
fonction around each operand of comparaison operators. Is there any bad
experiences with this ? Any side effects we should know about ? What
about having to create localized indexes (CREATE INDEX i ON
t(NLSSORT(col, 'NLS_SORT=FRENCH')); is this mandotory ?



Thanks alot for your help.



Alain
Received on Wed Nov 28 2001 - 02:30:07 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US