How use like with accent insensitive ?

[lsaudon]

I want to search for first names without accents, but I want first names with accents to appear.

ex: search e -> édouard, eva

[simolus3]

With search, are you referring to the fts5 extension? It looks like the default tokenizer is supposed to remove accents during the search, so I'd assume that should already work.

Or are you e.g. implementing search with a LIKE / MATCH expression?

[lsaudon]

I implementing search with LIKE but maybe i need to check fts5.

[simolus3]

For full-text search, I think fts5 is generally a much better option because it has support for tokenizers doing precisely what you're looking for here.

[lsaudon]

Do you have a exemple for use fts ?

[simolus3]

The example in examples/app defines an fts5 table here and uses that in this page.

[lsaudon]

I've made quite a bit of progress, but I have a problem that seems to be on the drift side.

I can't use * at the beginning of the string. ex: SELECT * FROM todo_items_fts WHERE todo_items_fts MATCH '*cce*'

SqliteException(1): while selecting from statement, unknown special query: cce*, SQL logic error (code 1)
  Causing statement: SELECT * FROM todo_items_fts WHERE todo_items_fts MATCH '*cce*'
package:sqlite3/src/implementation/exception.dart 95:3                              throwException
package:sqlite3/src/implementation/statement.dart 140:7                             StatementImplementation._selectResults
package:sqlite3/src/implementation/statement.dart 280:12                            StatementImplementation.selectWith
package:sqlite3/src/statement.dart 97:12                                            CommonPreparedStatement.select
package:drift/src/sqlite3/database.dart 161:27                                      Sqlite3Delegate.runSelect
package:drift/src/runtime/executor/helpers/engines.dart 78:19                       _BaseExecutor.runSelect.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62:20                       _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 75:26                       _BaseExecutor.runSelect
package:drift/src/runtime/query_builder/statements/select/custom_select.dart 51:45  CustomSelectStatement._executeRaw.<fn>
package:drift/src/runtime/api/connection_user.dart 171:16                           DatabaseConnectionUser.doWhenOpened.<fn>

I make a project for this "bug". Just run the tests.

https://github.com/lsaudon/drift_example/blob/main/test/todo_items_fts5_test.dart

[simolus3]

I don't think this is on the drift side, * has a special meaning in fts5. Does MATCH 'cce' alone work?