Set up a collation using sqlite3_create_collation
and then use it like this:
SELECT * FROM users WHERE name LIKE "Andre%" COLLATE NOACCENTS
More Related Contents:
- SQLite how to refer to column name by a query
- How do I unlock a SQLite database?
- “Insert if not exists” statement in SQLite
- SQLite Concurrent Access
- System.Data.SQLite Close() not releasing database file
- INSERT IF NOT EXISTS ELSE UPDATE?
- Sqlite LIMIT / OFFSET query
- Set start value for AUTOINCREMENT in SQLite
- How to use ROW_NUMBER in sqlite
- Android – Pulling SQlite database android device
- ALTER COLUMN in sqlite
- Python SQLite parameter substitution with wildcards in LIKE
- Efficient paging in SQLite with millions of records
- Sqlite group_concat ordering
- How to get a list of column names
- is there a limit to the size of a SQLite database?
- Access sqlite from a remote server
- sqlite – How to get INSERT OR IGNORE to work
- How do I add a new column in between two columns?
- Creating stored procedure and SQLite?
- How Scalable is SQLite? [closed]
- Are there any reserved words in SQLite?
- What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?
- Modify a Column’s Type in sqlite3
- How to set unique constraint over multiple columns when any one can be null?
- svn cleanup: sqlite: database disk image is malformed
- Truncate a SQLite table if it exists?
- Integration Testing Entity Framework code first with in-memory database
- How to get the number of rows of the selected result from sqlite3?
- How to get the last index of a substring in SQLite?