Home » SQL & PL/SQL » SQL & PL/SQL » NLS_COMP and NLS_SORT problems (merged)
NLS_COMP and NLS_SORT problems (merged) [message #293207] Fri, 11 January 2008 03:51 Go to next message
rohit1209
Messages: 5
Registered: January 2008
Location: Bangalore
Junior Member
Hi All,

I oracle version is 8.1.7

I'm very new to oracle
I'm running the query
alter session set nls_comp=ansi;
its working fine, but when i'm running
alter session set NLS_COMP=LINGUISTIC;
i'm getting an error
invalid or unknown NLS parameter value specified

NLS_SORT problem [message #293209 is a reply to message #293207] Fri, 11 January 2008 03:54 Go to previous messageGo to next message
rohit1209
Messages: 5
Registered: January 2008
Location: Bangalore
Junior Member
Hi All,

I oracle version is 8.1.7

I'm very new to oracle
I'm running the query
alter session set NLS_SORT=BINARY;
its working fine, but when i'm running
alter session set NLS_SORT=BINARY_CI;
i'm getting an error
invalid or unknown NLS parameter value specified

Re: NLS_SORT problem [message #293213 is a reply to message #293209] Fri, 11 January 2008 03:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
BINARY_CI does not exist in 8i.

Regards
Michel
Re: NLS_COMP problem [message #293214 is a reply to message #293207] Fri, 11 January 2008 03:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LINGUISTIC is not a valid value in 8i.

Regards
Michel
Re: NLS_COMP problem [message #293222 is a reply to message #293207] Fri, 11 January 2008 04:16 Go to previous messageGo to next message
rohit1209
Messages: 5
Registered: January 2008
Location: Bangalore
Junior Member
How to make oracle 8i, case insentive search.
Re: NLS_COMP problem [message #293224 is a reply to message #293222] Fri, 11 January 2008 04:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't directly.
You have to either force the data in the format you want (upper or lower) or add a new column with this format.

Regards
Michel
Re: NLS_SORT problem [message #293227 is a reply to message #293213] Fri, 11 January 2008 04:31 Go to previous messageGo to next message
rohit1209
Messages: 5
Registered: January 2008
Location: Bangalore
Junior Member
How to make oracle 8i case insentive search

select name from emp where name="a%"

it should return
Amit
ajay
alok
Anu

but i'm getting only
ajay
alok
Re: NLS_SORT problem [message #293230 is a reply to message #293227] Fri, 11 January 2008 04:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't, see my answer on your question on NLS_COMP.

Regards
Michel

[Edit: Add link to the other topic]

[Updated on: Fri, 11 January 2008 04:46]

Report message to a moderator

Re: NLS_SORT problem [message #293232 is a reply to message #293209] Fri, 11 January 2008 04:38 Go to previous message
rohit1209
Messages: 5
Registered: January 2008
Location: Bangalore
Junior Member
Hi

Thank you Michel.


Regards

Rohit
Previous Topic: creating table in remote database
Next Topic: Package compilation: Error: ORA-00980: synonym translation is no longer valid
Goto Forum:
  


Current Time: Sun Nov 03 01:09:36 CDT 2024