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

    Unanswered: Search case-insensitive


    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

    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