Uploaded image for project: 'Couchbase Lite'
  1. Couchbase Lite
  2. CBL-4131

SQL++ : Enhance COLLATE syntax to support locales for UNICODE Collator

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 3.1.0
    • 3.0.2
    • LiteCore
    • Security Level: Public
    • None
    • LiteCore 99
    • 5

    Description

      Currently when using QueryBuilder, we allow to specify locale for UNICODE collation BUT we don't have a way to do that when using SQL++.

      QueryBuilder Sample:

      QueryBuilder.select(SelectResult.property("string"))            .from(DataSource.database(baseTestDb))            .orderBy(Ordering.expression(Expression.property("string")                .collate(Collation.unicode())
      		 
      .setLocale("se")

      There is no standard syntax for this as well. We probably need to come up with one such as 

      `COLLATE UNICODE_<LOCALE>`

       

      Attachments

        Issue Links

          backports to

          Improvement - An improvement or enhancement to an existing feature or task. CBL-4167 SQL++ : COLLATE does not have a way to specify locale for UNICODE

          • Major - Major loss of function.
          • Closed
          is cloned by

          Improvement - An improvement or enhancement to an existing feature or task. CBL-4167 SQL++ : COLLATE does not have a way to specify locale for UNICODE

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              jianmin.zhao Jianmin Zhao
              pasin Pasin Suriyentrakorn
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty