This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
How can I perform a case insensitive query using Sqlite 3? I know I can add COLLATE NOCASE to the column, but can that be done in the designer or does it need done manually? Is there a way to do this across the entire lightspeed model?
select * FROM tableX WHERE tableX.Name = 'var1' ORDER BY tableX.Id COLLATE NOCASE LIMIT 1
|
|
|
|
|
COLLATE NOCASE would have to be added manually. You could probably do 'fake' case-insensitive comparisons by using ToUpper() in your queries, but if the semantics of the column are that it's case-insensitive then COLLATE NOCASE is obviously a better option. |
|
|
|
