On 31 Mar 2003 at 9:49, Dan Tran wrote: > I wont work for me, I dont have access to SQL layer.
You can declare your columns as VARCHAR BINARY rather than VARCHAR in your table creation. Another possibility might be to set your character set for the database to latin1csas rather than the default latin1. It's mentioned in Paul DuBois's "MySQL" book, but I don't see anything about it on the mysql.com site. > > 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. The binary operation is slow because it's not using the index. If you want a column to be case-sensitive, make it VARCHAR BINARY when you create the table. Then you shouldn't need to double your criteria (you can just use "WHERE login = 'Matt'"). -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
