Joshua,
I'm not really asking for a new feature. I'm just trying to get the
accent insensitive search to work. If you look at the 3.23 Change Log
http://www.mysql.com/doc/N/e/News-3.23.0.html
the ninth bullet says:
Changed LIKE character comparison to behave as =; This means that
'e' LIKE ''e' (if the line doesn't display correctly, the latter 'e'
means a French 'e' with a dot above) is now true.
So, I'm still thinking my configuration is messed up or something.
Brian
While I am not saying that a search feature should not be made for this, I
will say that 'é' and 'e' have different values, and thus wouldn't match...
Perhaps you could substitue a regular expression style search w/more
intelligence in your code, for each case where you may want to see an
accented character?
On Monday 10 September 2001 01:00 pm, you wrote:
Hello,
I'm still having problems with MySQL 3.23 being accent sensitive
during searches. However, I'm now tested to ensure I'm getting the
correct accented search term to MySQL.
Here's my test page, which includes a small database of names with 2
entries per name, one including an accented vowel.
http://www.sedl.org/accents.html
If you search for Jose (no accent on the e) you get Jose (no accent)
If you search for José (with accent on the é) you get José (with accent)
At first, I thought it might be a problem with MySQL not recieveing
the accented value in the search term correctly, but that still
doesn't answer why searching for Jose (no accent) doesn't act like
a wildcard to pull up the record with the accented value as well as
the unaccented value.
Brian
--
Brian Litke
Web Administrator
Southwest Educational Development Laboratory (SEDL)
(800 or 512) 476-6861 x-260
http://www.sedl.org/
-
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
