I am exploring the idea of using the built in MYSQL function Soundex any one got thoughts on the best way to achieve this?
I want it so that regardless of the programming environment others may use the resulting text conversion is constantly entered and retrieved from the DB. upon collection I shall be extracting 10 - 20 chars of another field to help identify the right entry the user should select from the names returned (register type program). eg. user entered XXX YYYY xXX YYY 23 anyplace rd xxX yyy 55 hope rd hope you get the idea of what I'm wanting to do here... I am using Sequel or my connections so want to stay within this framework if at all possible, I'm thinking about having a stored procedure to obtain and return the soundex generated result thus i can save the generated value as a string. the field I am using is defined a char(4) as I've read that this is likely to give the best results but again am open to other folks views as long as it can be replicated in other programming languages (I know for sure PHP will be one not sure of others ergo wanting something that will be consistent for ALL languages) regardless of how they connect to the MYSQL db. dave. -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
