You can create the column with a BINARY flag to make it case-sensitive, or use blobs, which are case-sensitive by nature.
You can also use the keyword BINARY to cast a column to case-sensitive in your query. From: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #Case_Sensitivity_Operators BINARY The BINARY operator casts the string following it to a binary string. This is an easy way to force a column comparison to be case-sensitive even if the column isn't defined as BINARY or BLOB: mysql> SELECT "a" = "A"; -> 1 mysql> SELECT BINARY "a" = "A"; -> 0 BINARY string is a shorthand for CAST(string AS BINARY). See section 6.3.5 Cast Functions. BINARY was introduced in MySQL Version 3.23.0. Note that in some context MySQL will not be able to use the index efficiently when you cast an indexed column to BINARY. If you want to compare a blob case-insensitively you can always convert the blob to upper case before doing the comparison: SELECT 'A' LIKE UPPER(blob_col) FROM table_name; We plan to soon introduce casting between different character sets to make string comparison even more flexible. ---John Holmes... > -----Original Message----- > From: fincom [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 07, 2002 5:43 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Re: PHP-MySQL AND Case Sentivity > > That's Ok > See : > > http://www.zend.com/tips/tips.php?id=199&single=1 > > > "Fincom" <[EMAIL PROTECTED]> a écrit dans le message de news: > [EMAIL PROTECTED] > > Hi, > > > > how to make sql Result case sensitive with php. > > > > thanks > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
