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

Home -> Community -> Usenet -> c.d.o.server -> NLS_COMP, NLS_SORT, VARCHAR2/NVARCHAR2

NLS_COMP, NLS_SORT, VARCHAR2/NVARCHAR2

From: <stvchien0_at_gmail.com>
Date: Sat, 24 Mar 2007 12:39:20 +0800
Message-ID: <fma903ddd5gm58qijog532bfkrgqpuvir7@4ax.com> 





Hi,



  Lately, we're running into a case-insensitive query issue with
Oracle 10.2g. 



  The NLS_COMP & NLS_SORT (for example, setting NLS_COMP to LINGUISTIC
& NLS_SORT to BINARY_CI) work pretty well with VARCHAR2 columes.
However, we found out that it didn't have the expected effects on
NVACHAR2 columns. 



  Any insight?



  Thanks in advance!




Received on Fri Mar 23 2007 - 23:39:20 CDT












Original text of this message













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