Accentuation

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
Post Reply
scassola
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Thu, 19 Jan 2006 1:16 pm
Location: SP

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
gilbertoca
Rank: DBA Sênior
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.

Select all

 
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'); 
I hope it helps!
Gilberto
scassola
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Thu, 19 Jan 2006 1:16 pm
Location: SP

Gilberto, the Oracle version I'm using is 9i and I tried what you suggested but it did not work here ... It does not give syntax error, but it does not return what I need ...

]Anyway, thank you.
Sandra
scassola
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Thu, 19 Jan 2006 1:16 pm
Location: SP

Oops !! I think I had done something wrong from the first time !! Now I tried again and it worked !!!

Thanks !!!!

Sandra
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 19 guests