gcue Posted September 14, 2010 Share Posted September 14, 2010 (edited) i have tried using COLLATE SQL_Latin1_General_CP1_CI_AS (for case insensitive) and COLLATE SQL_Latin1_General_CP1_CS_AS (for case sensitive)when i use these, i don't get any results. so there must be another syntax to query with these conditions?my query:_SQLite_Query(-1, "SELECT AssetTag FROM aAssetTracker_Login WHERE LastLogonUser='" & $search_text & "' OR PrimaryUser='" & $search_text & "' COLLATE SQL_Latin1_General_CP1_CI_AS", $hQuery) While _SQLite_FetchData($hQuery, $aRow) = $SQLITE_OK $asset_tag = $aRow[0] Wendthanks in advance. Edited September 14, 2010 by gcue Link to comment Share on other sites More sharing options...
gcue Posted September 14, 2010 Author Share Posted September 14, 2010 (edited) found it on google "COLLATE NOCASE" http://www.pubbs.net/201003/sqlite/69310-sqlite-case-sensitivity-performance-and-like.html thanks anyway! Edited September 14, 2010 by gcue Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now