Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-9944

Liferay Portal will automatically detect if MySQL is case sensitive

    Details

    • Branch Version/s:
      5.2.x, 5.1.x
    • Backported to Branch:
      Committed

      Description

      When Liferay portal is using MySQL and "database.mysql.function.lower.enabled" is set to false (the default setting), the portal automatically removes case sensitive searches to improve performance. If MySQL is using a case sensitive character set (such as latin1_general_cs), and the property is not set to true, this breaks case insensitive searches. Since users can overlook this property, "database.mysql.function.lower.enabled" will be removed and Liferay portal will automatically detect if MySQL is case sensitive or not.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                support-lep@liferay.com SE Support
                Reporter:
                douglas.wong Douglas Wong
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  7 years, 30 weeks ago