Bug #3556 soundex not working correctly
Submitted: 24 Apr 2004 11:26 Modified: 28 Apr 2004 14:03
Reporter: Edwin van Maastrigt Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.13 OS:Linux (linux)
Assigned to: Sergei Golubchik CPU Architecture:Any

[24 Apr 2004 11:26] Edwin van Maastrigt 
Description:
From the documentation on the SOUNDEX function:

"All non-alphabetic characters are ignored in the given string."

This is not true.

mysql> SELECT SOUNDEX('aap');
        -> 'A100'
mysql> SELECT SOUNDEX('"aap"');
        -> '"100'

It is either a bug in the documentation or a bug in the soundex algorithme.

I think the last

How to repeat:
mysql> SELECT SOUNDEX('aap');
        -> 'A100'
mysql> SELECT SOUNDEX('"aap"');
        -> '"100'
[28 Apr 2004 14:03] Sergei Golubchik 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

fixed in 4.0.19