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

SQL++ : COLLATE does not have a way to specify locale for UNICODE

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 3.0.12
    • 3.0.2
    • LiteCore
    • Security Level: Public
    • LiteCore 106
    • 2

    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

          Clones

          Improvement - An improvement or enhancement to an existing feature or task. CBL-4131 SQL++ : Enhance COLLATE syntax to support locales for UNICODE Collator

          • Major - Major loss of function.
          • Closed
          is a backport of

          Improvement - An improvement or enhancement to an existing feature or task. CBL-4131 SQL++ : Enhance COLLATE syntax to support locales for UNICODE Collator

          • Major - Major loss of function.
          • Closed

          Activity

            People

              jianmin.zhao Jianmin Zhao
              jianmin.zhao Jianmin Zhao
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty