Actually converting everything to upper-case (or lower-case) does not achieve case-insensitive comparison in all locales.
Here's a thread on the subject with examples in C#, but assuming consistent i18n support the issue would affect all programming environments. http://groups.google.com/group/microsoft.public.dotnet.framework.aspnet/brow se_thread/thread/23b40b19185821d9/9a60db731adb2159 Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: P Kishor [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 11:06 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Case Insensitive Equality Searches On 3/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > If I want to do "SELECT * FROM table WHERE field = value", how can I do this matching text only and not case? > you can do it in your application using the language of your choice by upcasing or downcasing your field and value. Here is a Perl example SELECT * FROM table WHERE upper(field) = uc($value) or, you can define your column (done at CREATE TABLE time) with a COLLATE NOCASE option. See <http://www.sqlite.org/datatype3.html#collation> -- Puneet Kishor http://punkish.eidesis.org/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
