New "binary" character set should appear in next release. It provides case-sensitive comparisons. It even doesn't require recompiling mysqld, you need just to put binary.conf file into /share directory of mysql installation, then restart mysqld with "--default-character-set=binary" argument. If you would like me to send binary.conf file, please let me know.
Keith C. Ivey wrote: > On 28 Jun 2002, at 14:27, Mark Hennessy wrote: > > >>I have noticed after migrating my database from mSQL to MySQL that >>queries are providing lookup results in a case-insensitive manner. > > > To avoid that, make your CHAR and VARCHAR columns BINARY, or if you > only want to make *some* comparisons case-sensitive, use BINARY in > your query: > > http://www.mysql.com/doc/C/H/CHAR.html > http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html > -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Barkov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia <___/ www.mysql.com +7-902-856-80-21 --------------------------------------------------------------------- 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