2 Replies Latest reply on May 14, 2012 10:18 PM by dmshimself

    Queries sometimes case sensitive

    neil_p1000 Apprentice

      Hi all


      we have found a weird quirk in our queries that we have designed for our CMDB. Some of them Seem to be case sensitive and some not.


      E.G we had a search for criteria for a workstations serial number and it returned no results as we typed the serial in lower case (once we typed it in upper case it found the item). bit of a problem as you really need it to find the item no matter what case you type in.


      Anybody had the same problem or is there a setting within the system?




        • 1. Re: Queries sometimes case sensitive
          karenpeacock SupportEmployee

          Hi Neil


          I had a feeling that I've seen this before on older versions when picking a certain criteria condition but I couldn't get this to go wrong on 7.5 when I just tried it.  Perhaps it may also be down to whether your database collation is set to be Case Sensitive or not, mine is Case Insensitive.


          Anyhow, I think a good place to start is to compare the criteria conditions between a query which is working the way you want it to and one which isn't.  Within Query and Report Designer modify your query and then on the 3rd screen it should show you the criteria to compare.


          Does this show anything which could be adjusted?


          Best wishes


          • 2. Re: Queries sometimes case sensitive

            If you are using Oracle then I'm afraid this is expected behaviour unless you apply the wonderful case insensitive trigger obtainable from your local support team and take the advice they will offer you on index creation.  With SQL Server as Karen points out if you are using a slightly unsupported character set or collation sequence then adjustments may be required before normal service is resumed.