I'm developing a project which uses soundex matching (amongside other options more sophisticated than that). This is custom software with a mariad back end. MariaDB soundex built-in produces codes of apparently arbitary length; the usual is 4 characters. I've come to the conclusion that the best way forward is to mimic Maria's soundex in the code. I cannt find a desciption of the algorith Maria uses though: the only source code I can find is in mf_soundex.c, and that is explicitly limited wo 4 characters. But I have installed triggers which generate codes such as A4152636125262 Where is the soundex function found? Anyone know?
Hi, apologies for the delay in sql/item_strfunc.cc there is Item_func_soundex::val_str which implements the SQL function. Maybe you want to look at https://github.com/pluots/sql-udf in which you can write your own UDF functions in Rust. On Thu, 25 Apr 2024 at 11:10, lucyfrost--- via discuss <discuss@lists.mariadb.org> wrote:
I'm developing a project which uses soundex matching (amongside other options more sophisticated than that). This is custom software with a mariad back end.
MariaDB soundex built-in produces codes of apparently arbitary length; the usual is 4 characters. I've come to the conclusion that the best way forward is to mimic Maria's soundex in the code.
I cannt find a desciption of the algorith Maria uses though: the only source code I can find is in mf_soundex.c, and that is explicitly limited wo 4 characters. But I have installed triggers which generate codes such as A4152636125262
Where is the soundex function found? Anyone know? _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
participants (2)
-
Daniel Black -
lucyfrost＠tutanota.com