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

          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:

                PagerDuty