Do you happen to know how to change the charset? I have read thru the manual, but I have no clue where to start.
Thanks in advance -Dan ----- Original Message ----- From: "Keith C. Ivey" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Cc: "Dan Tran" <[EMAIL PROTECTED]>; "Matt Gostick" <[EMAIL PROTECTED]> Sent: Monday, March 31, 2003 10:13 AM Subject: Re: Case-Sensitive database > 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]