Bug #48289 Soundex not truncating result.
| Submitted: | 25 Oct 2009 13:20 | Modified: | 25 Oct 2009 15:05 |
|---|---|---|---|
| Reporter: | Andrew Hutchings | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: General | Severity: | S3 (Non-critical) |
| Version: | 5.1.40 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[25 Oct 2009 13:59]
Andrew Hutchings
Verified in MySQL 5.1.40 and 5.0.86.
[25 Oct 2009 15:05]
Sergei Golubchik
It works as documented. See http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_soundex " A standard soundex string is four characters long, but the SOUNDEX() function returns an arbitrarily long string. You can use SUBSTRING() on the result to get a standard soundex string. "
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.048 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: The Soundex algorithm should truncate the result after the first 3 digits. This does not appear to be happening, yet zero-fill stops on the 3rd digit. How to repeat: mysql> select soundex('travelling'); +-----------------------+ | soundex('travelling') | +-----------------------+ | T61452 | +-----------------------+ 1 row in set (0.00 sec) mysql> select soundex('trav'); +-----------------+ | soundex('trav') | +-----------------+ | T610 | +-----------------+ 1 row in set (0.00 sec)