Re: [PHP] Case Sensitivity

2002-08-11 Thread Rasmus Lerdorf
Filesystems are meant to be case-sensitive, and yes, URL's are as well. It's an abomination that Windows and old-style Mac filesystems are not. You need to keep track of that in your code. 'a' and 'A' are just as different as 'a' and 'b'. -Rasmus On Sun, 11 Aug 2002, Rich Hutchins wrote: > I'v

Re: [PHP] Case Sensitivity

2002-08-11 Thread Andrew Brampton
;[EMAIL PROTECTED]> Sent: Monday, August 12, 2002 2:20 AM Subject: [PHP] Case Sensitivity > I've had a web site under development on my Win2k box at home. I built and > tested everything with PHP 4.2.2 and Apache 1.3.24. > > Now, I have transitioned everything up to my host who

[PHP] Case Sensitivity

2002-08-11 Thread Rich Hutchins
I've had a web site under development on my Win2k box at home. I built and tested everything with PHP 4.2.2 and Apache 1.3.24. Now, I have transitioned everything up to my host who is using a Linux box, PHP 4.2.2 and Apache 1.3.26. One of the pages I designed has code that retrieves a list of th

Re: [PHP] Case-Sensitivity with PHP and MySQL

2001-04-11 Thread Plutarck
I had a similar question about case-sensitivity, and I was told that MySQL is automatically case-insensitive! But it depends on your version of MySQL. Go to the mysql manual and look at chapter 20.16 "Case sensitivity in searches". In the newest versions of MySQL, all searches are case-insensiti

[PHP] Case-Sensitivity with PHP and MySQL

2001-04-11 Thread midget2000x
I am writing a PHP script that operates on a MySQL database that uses the e-mail address as the primary key. If the e-mail doesn't exist in the database (when a form is submitted), I want to insert a new record. If it does, I want to update the existing record. How can I make the query that

Re: [PHP] case sensitivity checking?

2001-02-15 Thread Martin A. Marques
El Jue 15 Feb 2001 16:41, James, Yz escribió: > > Oh, another thing. Anyone know of any tools like PHP MyAdmin for > PostGresSQL ? phpPgAdmin? http://www.greatbridge.org/project/phppgadmin/projdisplay.php Saludos... ;-) -- System Administration: It's a dirty job, but someone told I had to d

Re: [PHP] case sensitivity checking?

2001-02-15 Thread James, Yz
> make the login field BINARY. Thanks! ;) James. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] case sensitivity checking?

2001-02-15 Thread Mark Maggelet
On Thu, 15 Feb 2001 19:41:04 -, James, Yz ([EMAIL PROTECTED]) wrote: >Hi Guys, > >Just a quick question. If I have a user database, with joe_bloggs >as a >user, what would I need to do to make sure that his login details >matched >the case sensitivity in a MySQL database? Say if he logged in

[PHP] case sensitivity checking?

2001-02-15 Thread James, Yz
Hi Guys, Just a quick question. If I have a user database, with joe_bloggs as a user, what would I need to do to make sure that his login details matched the case sensitivity in a MySQL database? Say if he logged in as JOE_BLOGGS, could I return an error? I'm guessing this is going to turn int