Hi Richard, Richard Bolen wrote:
>If I understand correctly, you have to define a char field as binary if you want the >database to treat it as a 'case sensitive' field. Is there any way via a SQL query >to force case sensitivity to be used for a non-binary char field? i.e.: for >comparing strings in a case sensitive way. Or is there some way to force the >database to use case sensitive string comparisons all the time (even for non-binary >char fields)? > Yes, try this: select * from yourtable where binary field1= 'CASEsensitive'; > >I'm using the mm.mysql jdbc driver to access the database and it returns the data >differently if a field is defined as binary. This is causing my string data to be >garbled in my application for binary char fields. > >Rich > >-------------------------------------------------------------------- >Rich Bolen >Senior Software Developer >GretagMacbeth Advanced Technologies Center >79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 >PO Box 14026 >Research Triangle Park, North Carolina 27709-4026 USA >Phone: 919-549-7575 x239, Fax: 919-549-0421 > >http://www.gretagmacbeth.com/ >-------------------------------------------------------------------- > > >--------------------------------------------------------------------- >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 > > > > -- ------------------------------------------------------ \|/ ______ \|/ `@" / o . \ "@' Microsoft? Por acaso é alguma nova /___| \____/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\ http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ ------------------------------------------------------ --------------------------------------------------------------------- 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