Good afternoon people!
I need one thing I do not know if it is possible ... I need to pass a name as a condition and retrieve the information regardless of your accent. For example, I inform "José da Silva" and I want me to return the data from "José da Silva" and "Jose da Silva" without accent. Is this possible?
Thanks !!
Hugs,
Sandra
Accentuation
-
- Rank: DBA Sênior
- Posts: 372
- Joined: Tue, 24 Jan 2006 3:33 pm
- Location: Palmas - TO
- Contact:
Good afternoon, Sandra!
I am using the 10G version and in my manuals has a page demonstrating this characteristic.
Example: Deloguis, Deloguis, Delanges and Délis.
I hope it helps!
Gilberto
I am using the 10G version and in my manuals has a page demonstrating this characteristic.
Example: Deloguis, Deloguis, Delanges and Délis.
ALTER SESSION SET NLS_COMP=ANSI;
ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER;
SELECT CUST_LAST_NAME FROM OE.CUSTOMERS
WHERE CUST_LAST_NAME = NLS_UPPER('DeLuis');
Gilberto
-
- Information
-
Who is online
Users browsing this forum: No registered users and 19 guests