Jonas Sandman <[EMAIL PROTECTED]>
wrote:
Can I make SQLite use a collation function when making a simple query?
Before sending the data to LIKE I could override and for example
strip the accent (*á' would become 'a' and 'é' would become 'e' etc).
Recent versions of SQLite support syntax like this:
select * from tableName
where field = 'blah' collate MYCOLLATION;
That is, you can specify a collation to use for each comparison.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
