Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    1

    Unanswered: Search case-insensitive

    Hi,

    I use Informix in my application. I need to make search case-insensitive (if I look for A I have to find a,,,...)
    I have two solution:
    1. I could do a procedure what replace to A, a to A,... and also create indexes.
    2. I could have an additional column in the tables with all letters in uppercase and use that columns in the queries


    what solution do you think that is the correct?, could the solution 1 have impact in the performance?

    Thank in advance

  2. #2
    Join Date
    Jan 2011
    Posts
    1
    Hello,

    I think the first procedure is much better than the second one, it's only a matter of replacing the one that is incorrect with the correct one. However it depends whether the first one or the second one will work ? to make sure just try them both, in my opinion.
    __________________________________________________ _______________
    cannabis seeds

Posting Permissions

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