| Accent Isensitive and Case Sensitive [message #210635] |
Thu, 21 December 2006 10:56  |
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 #210778 is a reply to message #210707] |
Fri, 22 December 2006 05:07  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
