RE: Do index in MySQL is case insensitive?
Hi, Do you mean case insensitive when you do a like? a like is case insensitive, to make it sensitive do a LIKE BINARY 'abc', or use CLIKE (from memory, might be wrong). Robin -Original Message- From: Carfield Yim [mailto:[EMAIL PROTECTED]] Sent: 02 March 2001 10:42 To: '[EMAIL PROTECTED]' Subject: Do index in MySQL is case insensitive? I have heard from somebody that MySQL index is case insensitive. If this is true, how can I set it to case sensitive? - 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
Re: Do index in MySQL is case insensitive?
An index is an index and has nothing to do with case. This all depends on how you define your columns. Look up the section on column types in the manual. - Original Message - From: "Carfield Yim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 02, 2001 18:42 Subject: Do index in MySQL is case insensitive? > I have heard from somebody that MySQL index is case insensitive. If this is > true, how can I set it to case sensitive? > - 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