I wont work for me, I dont have access to SQL layer. I use JDO In Micorosft SQL Server I can specify the Collate during database creation to make my string case-sensitive. Is there an equivalent configuration for MySQL?
Thanks ahead for all suggestions -Dan ----- Original Message ----- From: "Matt Gostick" <[EMAIL PROTECTED]> To: "Dan Tran" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, March 31, 2003 9:41 AM Subject: Re: Case-Sensitive database > I'm not sure if you can do it globally... but here is what I do: > > select passwd > from blerg > where login = "Matt" > and binary login = "Matt"; > > I do it twice b/c the binary operation is quite slow and doing the > normal equate first speeds it up significantly. > > Doesn't exactly answer your question... sorry. > > Matt Gostick. > > On Mon, 2003-03-31 at 11:23, Dan Tran wrote: > > > > Hi, how do I configure mysql to be Case-Sensitive globally? > > (ie where, like, clauses work with case-sensitive strings > > > > Help is greatly appreciated. > > > > -Dan > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
