Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    13

    Unanswered: case in sensitivity

    Dear Experts,

    I've been working with a product development cmpany, and we are making our product to support all the main databases. we finished for sql server, oracle. presently we started with DB2. I dont know how to start with this. I even dont know how to find the version of this db2. I'm starting with a,b,c,d......

    friends, please help me how can i make my database case-in-sensitive? I've the following link, but with that I can not make my database collation case in sensitive. so please help me in this regard.
    We dont know whether the client inserts data in which case. but while we selecting, all these should be concidered.

    age=Age=AGe=AGE=aGE...................like that.

    we need to reuse the output in other queries..............please guide me

    http://www-128.ibm.com/developerwork...3adamache.html

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Code:
    SELECT *
    FROM mytable
    WHERE UCASE(field1) = UCASE('age');
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    May 2006
    Posts
    82
    This thread is duplicated. The same issue was presented few days later, by the same user and it is @
    http://www.dbforums.com/showthread.php?t=1616717
    Vinay,

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Thread locked. Responses to
    http://www.dbforums.com/showthread.php?t=1616717 please
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •