tag:blogger.com,1999:blog-16959946.post603315438310455699..comments2023-12-09T16:44:47.897+01:00Comments on The Data Charmer: Creative MySQL hacking and Summer of CodeGiuseppe Maxiahttp://www.blogger.com/profile/15801583338057324813noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-16959946.post-65589608784266043242008-03-18T17:30:00.000+01:002008-03-18T17:30:00.000+01:00Hi!You forgot one of the most charming extension p...Hi!<BR/><BR/>You forgot one of the most charming extension points: custom collations!!<BR/><BR/>Using a custom collation you can for example create a "phone" collation - one that sorts all interpunction as a single weight. <BR/><BR/>For example <BR/><BR/>+12819130892<BR/><BR/>and<BR/><BR/>+1 281 913 0892<BR/><BR/>and <BR/><BR/>12819130892<BR/><BR/>are all the same with this collation.<BR/><BR/>The advantage over stripping out those extra characters is that you can store the value as is, but enforce unicity without taking the non-digits into account.<BR/><BR/>And all of this is possible by just hacking a little xml file beneath your server dir...no recompilation, triggers, nada.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.com