Change theme
Help
Press space for more information.
Show links for this issue (Shortcut: i, l)
Copy issue ID
Previous Issue (Shortcut: k)
Next Issue (Shortcut: j)
Sign in to use full features.
Vote: I am impacted
Notification menu
Refresh (Shortcut: Shift+r)
Go home (Shortcut: u)
Pending code changes (auto-populated)
View issue level access limits(Press Alt + Right arrow for more information)
Unintended behavior
View staffing
Description
Version used:1.0.0-rc1
The collation sequences LOCALIZED and UNICODE are not are supported in Room, only BINARY, NOCASE, RTRIM and UNSPECIFIED.
Please add support for LOCALIZED as specified in
"In addition to SQLite's default BINARY collator, Android supplies two more, LOCALIZED, which changes with the system's current locale, and UNICODE, which is the Unicode Collation Algorithm and not tailored to the current locale."
Adding LOCALIZED to a @Query like
@Query("SELECT name FROM Users ORDER BY name COLLATE LOCALIZED ASC")
Results in:
"There is a problem with the query: [SQLITE_ERROR] SQL error or missing database (no such collation sequence: LOCALIZED)"