On Fri, 25 Mar 2011 10:35:37 +0100 "J Trahair" <[email protected]> wrote:
> If the SELECT statement is SELECT * FROM Customers WHERE CustomerCode = > 'tra001' that is, with tra001 in lower case, SQLite *does not find the > record*. SELECT * FROM Customers WHERE CustomerCode LIKE 'tra001' would do. There are exceptions, for non-ASCII characters in unicode - http://www.sqlite.org/lang_expr.html#like - however, the like function can be redefined to match your needs: http://www.sqlite.org/pragma.html#pragma_case_sensitive_like > SQL Server Express and MySQL - and even Access - do not have this > disadvantage. My opinion is that matching the exact string you want is not a "disadvantage", 'tra001' and 'TRA001' are different things, why would the equal sign match them?... -- Mihai Militaru <[email protected]> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
