Re: NLS_UPPER and French characters

Shona Helstrom wrote:

> 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

My suspicion is that you have a database with the wrong language defined. You should not have two different characters stored identically. Look into UTF8.

Daniel Morgan Received on Wed Aug 14 2002 - 00:23:06 CEST