Re: [PHP-DB] is SELECT case sensitive

2005-10-06 Thread roy . a . jones
ARMA Database Site "Ron Piggott" <[EMAIL PROTECTED]> 06-Oct-2005 03:02 Please respond to "Ron Piggott" <[EMAIL PROTECTED]> To "PHP DB" cc Subject [PHP-DB] is SELECT case sensitive Is SELECT typically case sensitive? Is there a way to make

Re: [PHP-DB] is SELECT case sensitive

2005-10-06 Thread Koen Wagemans
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 <[EMAIL PROTECTED]> wrote: > Is SELECT typically case sensitive? Is there a way to ma

[PHP-DB] is SELECT case sensitive

2005-10-06 Thread Ron Piggott
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: