I SWEAR to you that I am putting a space between WHEN and BINARY and user_name. I even typed it out manually using extra spaces between every command to be absolutely sure, but, MySQL insists on seeing BINARY user_name as BINARYuser_name no matter how many spaces I put between it. Here's what worked: WHEN BINARY(user_name)='Someone' > From: holmes072000@xxxxxxxxxxx (Cpt John W. Holmes) > Organization: U.S. Army > Reply-To: "CPT John W. Holmes" <holmes072000@xxxxxxxxxxx> > Newsgroups: php.db > Date: Mon, 5 Jan 2004 17:05:11 -0500 > To: <php-db@xxxxxxxxxxxxx>, "Monty" <monty3@xxxxxxxxxxx> > Subject: Re: Re: BINARY not recognized ?? > > From: "Monty" <monty3@xxxxxxxxxxx> > >> Hi John. The while the error message mashes BINARY and user_name together, >> that's not how I am typing it in my SELECT statement if you check my > example >> in the previous post. MySQL is doing this on it's own for some strange >> reason, even though there is clearly a space between the work BINARY and >> user_name in my statement. > > Hmmm... There's no reason MySQL would put them together in the error message > unless it was really sent that way to it. Do you print out the query in your > program just to _make sure_ it's getting sent correctly? If you copy and > paste from what you see printed out and try it from the command line, do you > get the same result? > > ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
