On 08/08/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Lee Crain <[EMAIL PROTECTED]> wrote: > > Would a search for an 'a' return a different result than a search for > > an 'A'? > > By default, yes. > > > SELECT * FROM table WHERE field1 = 'a'; > > > > Vs. > > > > SELECT * FROM table WHERE field1 = 'A'; > > > > If SQLite is case sensitive, is there an easy override for this to > > enforce > > all lowercase letters? > > select * from tableName where field1 = 'a' collate NOCASE; > -- or > select * from tableName where lower(field1) = 'a'; > > Igor Tandetnik
MySQL's text searches are by default _not_ case sensitive. Yet another example of the differences in the behaviour between the different SQL systems. Is there an existing wiki page or place on the web where this sort of thing is documented? This sort of information is gold, and while I've only been on the mailing list a short time, many of the messages have revolved around the SQL language and varying behaviours across platforms. thanks Paul ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------