MySQL is not Oracle ... and that's a good thing, too! :-) Tom Haapanen [EMAIL PROTECTED]
-----Original Message----- From: Joe Kaiping [mailto:[EMAIL PROTECTED]] Sent: 30 September 2001 19:37 To: [EMAIL PROTECTED] Subject: RE: why would LOWER Thanks to all for your responses. I had missed this important piece of information in the documentation that Benjamin pointed to and: http://www.mysql.com/doc/C/H/CHAR.html "Values in CHAR and VARCHAR columns are sorted and compared in case-insensitive fashion, unless the BINARY attribute was specified when the table was created. The BINARY attribute means that column values are sorted and compared in case-sensitive fashion according to the ASCII order of the machine where the MySQL server is running. BINARY doesn't affect how the column is stored or retrieved." -Joe --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
