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 -> Case insensitive/ sensitive

Case insensitive/ sensitive

From: <sevinge_at_my-dejanews.com>
Date: Tue, 25 Aug 1998 07:28:13 GMT
Message-ID: <6rtp2d$757$1@nnrp1.dejanews.com>

    Hi, friends!
    We have done a migration from SQL Server to Oracle 7.3.

    One problem we cannot resolve is the string comparison, because SQL Server doesn't distinct letter case. By default, Oracle distingues the case. We looked for a 'set variable' but this donĀ“t work what we want. The sql-case variable only permits those three values: lower, upper, mixed, but not the INSENSITIVE CASE.

    Anyone know how to do this? Thanks .

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 25 1998 - 02:28:13 CDT

Original text of this message

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