Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Switch Database to CASE INSENSITIVE mode

Switch Database to CASE INSENSITIVE mode

From: Paul CHELARU <pchelaru_at_concord.com.au>
Date: Thu, 20 Sep 2001 10:37:40 +1000
Message-ID: <3ba93a58$1@news.iprimus.com.au> 





We want to port our applications to Oracle platform . At the moment our MS
SQL Server or Sybase SQLAnywhere are used in CASE INSENSITIVE mode. It is
not feasible to modify any


 sql statement to use ... where  upper(column) = 'MY_STRING'.  Is there any
way to solve this problem using a server switch or may be a special
collation .



TIA


Paul
Received on Wed Sep 19 2001 - 19:37:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US