> The problem is that I dont want it case sensitive, but > I do want it to distinguish special characters, any > more ideas?
You can't do this without a recompilation of MySQL. The manual sec. 4.6.3 - "Adding a New Character Set" gives a thorough explanation on how to go about it. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq > > 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 > > --------------------------------------------------------------------- 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
