Home » RDBMS Server » Server Administration » Case-insensitive sort order
Case-insensitive sort order [message #54153] Thu, 31 October 2002 18:17 Go to next message
mitra fatolahi
Messages: 38
Registered: October 2002
Member
Hello Everyone,

I've installed ORACLE 9i database and i've noticed all my entries and all the names for the objects that i created are changed to upper case letters even though i had entered lower case letters.

I don't think, the ORACLE 9i installer ever asked me what character sort order do i want to install.

I do have some experience with MSSQL Server 7 and during install we get to select either the case-insensitive sort order or the case-sensitive sort order.

Can someone plese tell me why ORACLE 9i changes all entries to the upper case. And what happens when ORACLE 9i needs to compare characters to see if they are equal?

I appreciate if someone can give me some info!

Thank you,
Mitra

Report message to a moderator

Re: Case-insensitive sort order [message #54165 is a reply to message #54153] Fri, 01 November 2002 05:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it is default for all oracle versions not just for oracle9i.
the names of objects (tables,indexes) are stored as ALLCAPS.
in oracle objectnames( like tablesnames,columnnames)
are case insensitive, but oracle data is case sensitive.
also pls have a look on our other posting
http://www.orafaq.net/msgboard/windows/messages/1783.htm

Report message to a moderator

oracle case insensitive [message #54450 is a reply to message #54153] Tue, 19 November 2002 01:48 Go to previous message
K. Prakash babu
Messages: 46
Registered: July 2001
Member
Hi
Can anybody, let me know if there is any way to make oracle case insensitive??

Report message to a moderator

Previous Topic: oracle = connect failed
Next Topic: diff. between global database name & database name
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 11 12:19:34 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.