search

davidmartos96 / sqflite_sqlcipher

SQLite flutter plugin
BSD 2-Clause "Simplified" License
99 stars 44 forks source link

COLLATE LOCALIZED not working #38

Closed Aksoyhlc closed 3 years ago

Aksoyhlc commented 3 years ago

Dart Unhandled Exception: DatabaseException(no such collation sequence: LOCALIZED: , while compiling: SELECT * FROM menu WHERE status=1 ORDER BY title COLLATE LOCALIZED ASC )}, stack trace: #0 SqfliteSqlCipherDatabaseFactoryImpl.wrapDatabaseException (package:sqflite_sqlcipher/src/factory_sql_cipher_impl.dart:44:9)

davidmartos96 commented 3 years ago

@Aksoyhlc Hello! I wasn't aware lf this, but it looks like it is a limitation of the native SqlCipher binary that it's used by this package. Here you have more information. Unfortunately I cannot do anything about it, this is a wrapper of said official native library.

https://discuss.zetetic.net/t/workaround-for-using-androids-localized-collator-after-3-5-0-update/1515