Following this documentation from oracle.
The example select soundex('SACHS' from dual; should be return S200, but I received S220 in many different oracle version.
Anyone have any idea? Thanks and best regards!
Asked
Active
Viewed 57 times
1
Johnnathan Almeida
- 11
- 1
-
Agreed. Looks like a bug. More obvious example: `soundex('ShShSwS')` (h and w) – Sayan Malakshinov Apr 12 '22 at 20:07
-
Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Apr 12 '22 at 22:09
-
It appears that Oracle is using the "SQL Soundex" algorithm, as documented at [this Wikipedia page](https://en.wikipedia.org/wiki/Soundex#American_Soundex) rather than the algorithm which is shown in their documentation. SQL Soundex produces "S220" for an input of "SACHS", while "normal" Soundex produces "S200". "SQL Soundex" and "American Soundex" differ principally in their treatment of "H", "W", and "Y". – Bob Jarvis - Слава Україні Apr 13 '22 at 19:07