You can specify a varchar field as binary, for instance: field1 varchar(50) binary
query, sql Mike -----Original Message----- From: asp52 [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:50 AM To: Mike Grabski; [EMAIL PROTECTED] Subject: Re: Case sensitivity Thanks, Just worked it out with binary statement in my query. all fine. Would it be wise to use binary type table? didnt try that as i wanted a flexible table of type varchar to perserve space. what would be its impact? cheers. Adamji From: "Mike Grabski" <[EMAIL PROTECTED]> To: "'asp52'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, December 19, 2002 2:29 PM Subject: RE: Case sensitivity > You have two choices, you can use a binary datatype for the field, or force > a binary comparison using the BINARY operator. > > http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html > http://www.mysql.com/doc/en/Column_types.html > > > query, sql > > Mike > > > > -----Original Message----- > From: asp52 [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 19, 2002 9:06 AM > To: [EMAIL PROTECTED] > Subject: Case sensitivity > > > Hi, > I have been searching tables based on search values which turn up tobe fine, > however the results dont reflect case sensitivity. > > what i mean, > > if i run following query > > select field1 from table1 where name='text1'; > > this works fine but returns the same result set with text1 values of 'USER' > or 'user'. > > i need to run the query which should run case sensitive. ie USER is > different from user > > Thanks in advance who can throw some ligth > > Adamji > > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
