Re: Re: BINARY not recognized ??

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux