Home » SQL & PL/SQL » SQL & PL/SQL » Accent question
Accent question [message #8780] Thu, 25 September 2003 06:55 Go to next message
arseni
Messages: 8
Registered: March 2003
Junior Member
Hi.
For example:
I have to realise a comparison or a searching between two records with word fields like Peter and Péter (with accent).
How can I do this and not consider accent as a difference between this two words (Peter = Péter)?
Is it a pl/sql question o something about oracle configuration?

Thanks.
Re: Accent question [message #8783 is a reply to message #8780] Thu, 25 September 2003 07:11 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
mag@mutation_mutation > select * from sound;

NAME
----------
smith
smythe
SMITH
smithe
peter
PETER
peiter

7 rows selected.

mag@mutation_mutation > select name from sound where soundex(name)=soundex('peter');

NAME
----------
peter
PETER
peiter

mag@mutation_mutation >  select name from sound where soundex(name)=soundex('smith');

NAME
----------
smith
smythe
SMITH
smithe

Previous Topic: Connect String
Next Topic: Alternate keys
Goto Forum:
  


Current Time: Fri Mar 29 05:56:11 CDT 2024