Announcement

Collapse
No announcement yet.

QUICK SEARCH: searching result is case sensitive {HELP}

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • QUICK SEARCH: searching result is case sensitive {HELP}

    Hi guys,

    some how after update the SC now the Quick Search result showing the CASE SENSITIVE,
    is there any way to fix this bug...


    I'm using SC ver: 5.02.0040

    thanks in advance
    ahmer

  • #2
    Re: QUICK SEARCH: searching result is case sensitive {HELP}

    Hello Ahmer,

    I was unable to run into this error on my Server. It shouldn't happen at all, as Scriptcase only queries your RDBMS (for instance, "SELECT * FROM myTable where someField like '%someValue%'). Make sure that your database collation is not case sensitive, and let me know if your collation is Case sensitive .

    regards,
    Bartho

    Comment


    • #3
      Re: QUICK SEARCH: searching result is case sensitive {HELP}

      thanks bartho,

      you are right, it is case-sensitive,
      would you please guide me how to fix this...

      thanks in advance
      ahmer

      Comment


      • #4
        Re: QUICK SEARCH: searching result is case sensitive {HELP}

        Hello Ahmer,

        Which RDBMS are you working with?

        regards,
        Bartho

        Comment


        • #5
          Re: QUICK SEARCH: searching result is case sensitive {HELP}

          I'm using MySQL ver. 5.0.51a

          Comment


          • #6
            Re: QUICK SEARCH: searching result is case sensitive {HELP}

            Hello,

            If you are using a DB Client (e.j. phpmyadmin) select your database and under the Settings / Operations (I'm not sure as my phpmyadmin is in portuguese) you can set a collation of your choice to the whole database.

            If you aren't, then you can alter the DB collation by the following SQL Statement:

            ALTER DATABASE `myDB` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci

            Note that on this example I'm setting the collation to latin1_swedish_ci, you can set to any other collation.

            regards,
            Bernhard Bernsmann

            Comment


            • #7
              Re: QUICK SEARCH: searching result is case sensitive {HELP}

              thanks bartho

              I did change, but still getting result with case sensitive...

              Comment


              • #8
                Re: QUICK SEARCH: searching result is case sensitive {HELP}

                Hello,

                That is strange. Have you tried querying your table directly from your RDBMS? Is it case sensitive or insensitive?

                regards,
                Bernhard Bernsmann

                Comment


                • #9
                  Re: QUICK SEARCH: searching result is case sensitive {HELP}

                  thanks bartho,

                  I tested as you said in phpmyadmin, and its same problem its still searching case sensitive.
                  please advice

                  regards
                  ahmer

                  Comment


                  • #10
                    Re: QUICK SEARCH: searching result is case sensitive {HELP}

                    Hello,

                    Could you try querying a upper case record using lower case query on phpMyAdmin?

                    regards,
                    Bernhard Bernsmann

                    Comment


                    • #11
                      Re: QUICK SEARCH: searching result is case sensitive {HELP}

                      Thanks Bartho

                      its saved in upper case, and its not searching in lower case, but it search is in upper case only...
                      please advice...

                      thanks
                      ahmer

                      Comment


                      • #12
                        Re: QUICK SEARCH: searching result is case sensitive {HELP}

                        Ahmer,

                        In that case your collation it still is CASE SENSITIVE. Make sure to select another collation that is Case Insensitive, try a few queries around your table to make sure that your DB is Case Insensitive.

                        regards,
                        Bernhard Bernsmann

                        Comment


                        • #13
                          Re: QUICK SEARCH: searching result is case sensitive {HELP}

                          Ahmer

                          Have you tried removing the Collation off the table that is now case sensitive ?

                          Paul

                          Comment


                          • #14
                            Re: QUICK SEARCH: searching result is case sensitive {HELP}

                            I tried many time to change the collation but still, i need USA collation
                            what should I select on phpmyadmin
                            any idea
                            thanks in advance

                            Comment


                            • #15
                              Re: QUICK SEARCH: searching result is case sensitive {HELP}

                              I've same problem. How ever from my phpmyadmin setup, is case insensitive.

                              Comment

                              Working...
                              X