Home » RDBMS Server » Server Administration » Accent Isensitive and Case Sensitive
Accent Isensitive and Case Sensitive [message #210635] Thu, 21 December 2006 10:56 Go to next message
A.R.F.
Messages: 3
Registered: December 2006
Location: Brazil
Junior Member
Hi,
How can make I to have Accent Insensitive and Case Sensitive?

AFAIK, if I to define as Accent Insensitive, automatically the Oracle defined as Case Insensitive too.

ARF.
Re: Accent Isensitive and Case Sensitive [message #210664 is a reply to message #210635] Thu, 21 December 2006 12:38 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
See if soundex() function helps.
Re: Accent Isensitive and Case Sensitive [message #210672 is a reply to message #210664] Thu, 21 December 2006 13:24 Go to previous messageGo to next message
A.R.F.
Messages: 3
Registered: December 2006
Location: Brazil
Junior Member
No, soundex() no, so exists other functions (upper, lower...) that help, but I dont want to use this functions. I need to use native configurations, as NLS_SORT.
Re: Accent Isensitive and Case Sensitive [message #210707 is a reply to message #210672] Thu, 21 December 2006 22:32 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi,

Check this link

http://www.orafaq.com/forum/m/206169/0/?srch=case+sensitive#msg_206169
Re: Accent Isensitive and Case Sensitive [message #210778 is a reply to message #210707] Fri, 22 December 2006 05:07 Go to previous messageGo to next message
A.R.F.
Messages: 3
Registered: December 2006
Location: Brazil
Junior Member
Hi seema.taunk.

All the messages and links that you it suggested, show only on Case Sensitive or Insensitive. But they do not show on Accent Insensitive and Case Sensitive, that are what I need.
I continue waiting for a solution.
If you to want can make a test:

create table test (col1 varchar2(20));
insert into table test values ('pepe');
insert into table test values ('pépe');
insert into table test values ('pepé');
insert into table test values ('Pepe');
insert into table test values ('Pépe');
insert into table test values ('Pepé');

In my sql, i want:
1 - select * from test where col1 like 'pe%';

And my desired result is:
col1
pepe
pépe
pepé

2 - select * from test where col1 like 'Pe%';

And my desired result is:
col1
Pepe
Pépe
Pepé

If somebody will be able to make this to work, solved my problem.
Re: Accent Isensitive and Case Sensitive [message #210788 is a reply to message #210778] Fri, 22 December 2006 06:26 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Would this help?
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10749/ch5lingsort.htm#i1009059

EDIT:
And i already doubt it. Apologies.
Just read your first post
>>AFAIK, if I to define as Accent Insensitive, automatically the Oracle defined as Case Insensitive too
seems yes.

[Updated on: Fri, 22 December 2006 06:30]

Report message to a moderator

Previous Topic: How to erase these old archive log files exactly?
Next Topic: Building database from hot backup
Goto Forum:
  


Current Time: Wed Dec 07 12:23:31 CST 2016

Total time taken to generate the page: 0.09580 seconds