Re: is SELECT case sensitive

[Koen Wagemans <koen.wagemans@xxxxxxxxx>]

Select on type varchar is not case sensitive, you can make it case
sensitive with the BINARY option:

 SELECT * FROM table_name WHERE  BINARY  column  LIKE '$searching_criteria';



Koen

On 06/10/05, Ron Piggott <ron.php@xxxxxxxxxxxxxxxxxx> wrote:
> Is SELECT typically case sensitive?  Is there a way to make it case
> sensitive?  (In the example below can $searching_criteria become case
> sensitive?)
>
> SELECT * FROM table_name WHERE column  LIKE '$searching_criteria';
>
> Ron
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php