The problem is that I dont want it case sensitive, but I do want it to distinguish special characters, any more ideas?
Thanks Shannon --- Michael Brunson <[EMAIL PROTECTED]> wrote: > On Fri, 21 Dec 2001 11:07:27 -0800 (PST), Shannon > Kendrick <[EMAIL PROTECTED]> wrote: > > | I have a mysql table (MySAM), a field in there is > set > | to unique, however the field does not seem to > | recognise the difference between certain ascii > | characters, for example it things that > | > | multimedia and multimèdia are the same (I hope it > is > | shown correctly) but basically it dos not > recognise > | characters like an e with an acute accent to be > | different from a normal "e" > | > | Anyone know how I can fix this? > > > Set the field type as BINARY, that will make it case > sensitive. > > > > Thanks, > Michael > -- > Michael Brunson > 504.473.6643 > [EMAIL PROTECTED] ICQ: > 83163789 > <? Special Projects Programming Manager ?> > --- Intercosmos Media Group, Inc. --- > www.intercosmos.com www.directnic.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 > __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.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