Re: Forcing case sensitivity via a query?
On 22 May 2002, at 14:52, Richard Bolen wrote: > 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. SELECT * FROM users WHERE BINARY password = 'cAsE_MAttErS'; http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org - 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: Forcing case sensitivity via a query?
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
Forcing case sensitivity via a query?
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)? 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