This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
To: "'Mike<mickalo>Blezien '" <mickalo@bellsouth.net>, From: "Sterin, Ilya" <Isterin@ciber.com> Subject: RE: Case Sensitivity Date: Wed, 3 Jan 2001 07:54:35 -0700 select this from that where name = 'Abc' would do just that. References to data are by default case sensitive, but if you need a non case sensitive search people get around by using select this from that where upper(name) = 'ABC'; this will match capitals. === To: dbi-users@isc.org, mickalo@bellsouth.net From: "Bodo Eing" <eingb@uni-muenster.de> Subject: Re: Case Sensitivity Date: Wed, 3 Jan 2001 16:13:39 +0100 From: "Mike<mickalo>Blezien" <mickalo@bellsouth.net> > I realize this is bit more a SQL query question then DBI, > but was hoping = some one could shed some lite on this. I > have simple query, and it needs to be= case sensitive: > $name =3D "Abc"; > SELECT a_name FROM a_table WHERE a_name=3D$name > Is there a way to force the query to ONLY find "Abc" and > not "ABC, = abc..etc"..? This depends on the database management system (DBMS) you are using; some support case-sensitivity, some do not. For example, MS Access does not support case-sensitive queries (at least not by default), DBD::CSV does. If you tell us your DBMS, perhaps the people familiar with it can give you more advice. === To: "Bodo Eing" <eingb@uni-muenster.de> From: "Mike<mickalo>Blezien" <mickalo@bellsouth.net> Subject: Re: Case Sensitivity Date: Wed, 03 Jan 2001 09:19:55 -0600 On Wed, 3 Jan 2001 16:13:39 +0100, "Bodo Eing" <eingb@uni-muenster.de> = wrote: I'm using Mysql database. === To: "Sterin, Ilya" <Isterin@ciber.com> From: Michael Peppler <mpeppler@peppler.org> Subject: RE: Case Sensitivity Date: Wed, 3 Jan 2001 07:52:44 -0800 (PST) Sterin, Ilya writes: > > select this from that where name = 'Abc' > would do just that. References to data are by default case sensitive This actually depends on the database server, and how it is set up. Sybase can be configured with various "sort orders", which can be case-insensitive (in which case the entire server is case-insensitive.) I suspect that MS-SQL has the same (or a similar) feature. ===