On Mar 19, 7:40 pm, dave <[email protected]> wrote: > 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.
If you want to have all connections to the database be able to use the code, then a stored procedure or user defined function would work best. Jeremy -- 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.
