RE: Help! Languages and Characters....
> 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 > > > > --- Intercosmos Media Group, Inc. --- > > www.intercosmos.comwww.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
Re: Help! Languages and Characters....
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 > > --- Intercosmos Media Group, Inc. --- > www.intercosmos.comwww.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
Re: Help! Languages and Characters....
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 --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.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
Help! Languages and Characters....
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? Thanks Shannon __ 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