| Bug #2969 | Return values from Soundex function | ||
|---|---|---|---|
| Submitted: | 26 Feb 2004 3:55 | Modified: | 5 Mar 2004 9:04 |
| Reporter: | [ name withheld ] | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 4.0.11 | OS: | Linux (Linux) |
| Assigned to: | Sergei Golubchik | CPU Architecture: | Any |
[26 Feb 2004 9:57]
Dean Ellis
Our algorithm is different, but I am going to verify this in the event that we want to alter this to follow the normal algorithm. For JACKSON, it sees JCK as part of the same group (ignoring the A), hence J500 rather than J250.
[5 Mar 2004 9:04]
Sergei Golubchik
Sorry, but the bug system is not the appropriate forum for asking support questions. Your problem is not the result of a bug. For a list of more appropriate places to ask for help using MySQL products, please visit http://www.mysql.com/support/ Thank you for your interest in MySQL. Additional info: This is not a bug. We use the original soundex algorithm, not the more popular enhanced version. The difference is that in the original algorithm vowels are removed *before* duplicate removal, and in the enhanced version - after. We'll explain it in the manual.
Description: Hi, I have found some strange results while doing soundex on the follwing word Word MySQL Soundex Value Standard Soundex Value Jackson J500 J250 Is the implrmentation of soundex algorithm is different in MySql or is this a bug? Kind Regards How to repeat: mysql> select soundex('KING');