NLS_UPPER and French

From: Shona Helstrom <gingersnap133_at_hotmail.com>
Date: 13 Aug 2002 15:05:43 -0700
Message-ID: <ffc8f296.0208131405.6c3bb051@posting.google.com>

Hi,

We are trying to implement a search on a column that contains french characters. The problem is that the é is stored as i and doing a search on both the é and the i both returns values, when we only want to return the é value.

We have tried using the nls_upper with the following sql

select * from table where nls_upper(column, 'NLS_SORT=French') like nls_upper('%é%', 'NLS_SORT=French')

Does anyone have any thoughts
Thanks in Advance
Shona
gingersnap133_at_hotmail.com Received on Tue Aug 13 2002 - 17:05:43 CDT