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