Some days ago, one of my customer claimed that searching for \u201cMuller\u201d doesn\u2019t return \u201cMueller\u201d and \u201cM\u00fcller\u201d as well!
\nThis is typically an issue due to the collation of the SQL Server database, but how to resolve this problem?
\nThe collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation.<\/p>\n
If a run the following query:<\/p>\n
Select name from Person where name like 'muller'<\/pre>\n[img64 src=”data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAABRCAIAAAAYU35CAAAHXElEQVR4nO2dT2\/iOBiH\/Z0cKuW7TIo44M+xhRmpJ3qr5BsHlBZt9kKlnrmsShurndWuRKWKU7WzNC0l6WX4Uyl7MHFiSGjoYBLgfWTR2LGjNHn6swOMBrmu57qu67pDUYbucOi+RsvrrAyC8jpXhu7rcPg6XBV37QTnv+OkvBpedqD131tg7wGxACVwsbysTwPYNTzPQ7e3d9YukvW13Ws8z0Oj0djfOUCsbNllsfaHrC2KwfM8NBrvplhZX9sNkc\/fdJlYhLLYgsl82bA0abAsa+6Nn3a73W63WzL1eiOLN6HWyVaKRZk\/K9QnCWVbxKJ0\/jwdxyGUZmLDGtlKsT7MKkwYxgliPZzoSIJcfsqRhxNdP3lYcZBlWa8yQizP89iLz15888YlhL5uOfkVa5wgVvRP3LZtsd1ut\/nGaDSilGFMUgnxKT\/CgSsOTxKr2+0yxmzbNm9cShmIpYi0YgmZfN9vtVq+749GI8\/zKGW6ri8TIqxfks9l1mfFGshQyihjrVaLUlavN3ghhA5SYn\/VEELFplTXvtppx6ti+8Sq1xvdbte27bYMvzd85buCWKIaTpGz3aJBP3mQRoVKEaKHI6T+yWK9yCyuscwbdxZdjFHGer3eyxKuq5qmaVr1WlQRQqKaHfkUy3VdNB5PksQS29HEopTxj6\/Zi1+vN5aJFbPEiogz2wyS7OFER+QyXqxoYsn9VxHr8fHRcRzHcRjzzRvXvHGjvxTGZJlb11VNq1YPA5XOD7XDQw3ESiZRrNipcDQatVotsf79QKwwUgIL5m3jysjx9YFYcv9ksZ5lKGW9Xk\/KXcb47+lTQimzbZu79RzLdVXTqtfnh1r1+vn5+fxQq55XNV7h6YV4gj1HG+b2B2PD3\/\/w\/FkasDgm4ZiC7RPr9PSUMcZvg1id8FexTKGUpp0KedAkx8wlQShVYsn9k8VyZBanwplYvu\/7fq\/Xw4RgTDAmTiydCsaVDn91zoxwe\/Yj7OOcGcg441VknM1XF44Z3ZH2mCFbKVZ4Dyjjq3XP8+r1Bnvx+Wxyenqa9qlw0Swx9yGx+NJPHiJr\/EuCFsWa77+aWDxrHcdhL4FYlPiE+L5PKKaUYbJULKdTwcYZv8tCNSmDw6aIGtGqaIh0F\/vSHnNXxOLTn1hXiTXKKmIJpS7JksW7tLjXI0rxUdJ0unzx\/iQjxOJWsRdprvc8r9frUcYwJk+x8FvOf2JsmEFLp4KRYcaNMA2EIruCqmkgXOlEjhkcWWpJd8ynp6etFEs8A0anP\/4weBqQKFamWJbVl+EaCasYC8QixCf48fGRUMzF6sdydYTx0RXfQIYZtoh6sOvqCCPRFR+ZcvXKNILufdNAi0dIc8yr8Ly2Uixd1zEmc6\/RDc4mjUnJB2IxnzAsHnsdx+l2u+12mz8bfiBWTItpBHMWr18d4Wg9qRrflO6YWyzWVmNZ1n8y\/LmPv03Ky0wsgn2CbdvGBHOx\/suQxhf0pbHSCBBro1iW9UOGL8yLxSImhBcu1uwN0mCux5j82DSNL5EE++3P1QaDWBtlUaxFuEaL5XN2ZAWItVEsy\/p3P8izWLv5DVIgQ25vb3dTLCBbRqNRKNbvf1xAgbKWcvf9b0msd5X0vanS46en702z+2PeC8bjMYgFrB8QC1ACiAUoAcQClDCZTEAsYP2AWIASMhXrvqbrtVp59ulr+eL9\/f39ohx+Hlu+4H3KZf4l99pFbbZxPxsefCGQN6x0Jtle950na7ECn7hk93N79dr9fU3n3kQ39Np9dMDi2BRnku1133mm02nGiXU\/tx3mEEJcLNEe3Yh2Wz20QCzV5E2sizKSc2iZWOVPny6IpZocihXowh1LEus9YtbqkoFYqsmbWNJMuFSs98hCHxbvuSNTsbIDxFINiAUoAcQClABiAUqYF6vvTfekZHvdd555sZT\/yw2E8vCa7UXfB2LEUjcBua7bH7xlXlzXXX5RgF9n02IhhDIXCxJrA0BiAUqAxAKUkF6syKd4vyBW\/M1mxxpCqGgFLXeVAkKF405sz8Jxh79CYuWYNGKJj+\/WIFZ8YrFjrXAQusI9UyYWJNYGyE1iFY4rxYMKe+sP3vrNklYsxasDibUlbFqs5MQ67jRL2re7\/uDNLB5UmgsCRZUS7TzbEELooMJ4n5JRQAiVTEisTMlRYgW6WMaiQPFi3VUKQciJdhS0QGJlSp4Sa3BXKZTMZgkVrZgpb1GsMK6C0GqmmiIhsTZAnhJr8Nb5dqAVDoxm3FoqXix5yku39oLE2gC5Siy+ZiqZYYtlCHWaJRQzFSKjKR4kS2Y6sSCxNkC+Eis2w2YTHX8\/Yj7JLGN+8Q6JlQvgnXdACfBZIaAESCxACZBYgBJixFL3bWBIrP1h019NduF7yfvBvFjZng2wM4BYgBJALEAJIBagBC7W7H\/\/ArGAdQFiAUoAsQAlgFiAEkAsQAkgFqAEEAtQAogFKAHEApQwnU7RZAJiAWtmOp2inz9\/TiaTyWTy\/a9\/JhJTAPgc4\/H4fy\/F9ip\/4wJNAAAAAElFTkSuQmCC” alt=””]
\nI get only \u201cMuller\u201d which is normal as I use an accent sensitive collation so u<\/strong> is not the same as \u00fc<\/strong>\u2026
\nNext, if I execute the same query by using an accent insensitive collation:<\/p>\nSelect name from Person where name like 'muller' collate Latin1_GENERAL_CI_AI<\/pre>\nI have as result:<\/p>\n
[img64 src=”data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKcAAABeCAIAAADJ6ZNqAAAIdUlEQVR4nO2dTW\/quBqA\/Z8cKoXfclLEov4dU5iRumpZVfKORZUW3dwNlVizGZUWz+mM7pWohFhVM0NTaKFzWhKo5Fk4cT6BhAKhtR9ZNHY+FPLkfe2EFMDrm2XbU8ueWvZ0Yk0n1vTNst8m9uvEfn2zf7zZP16tf+aUH6\/Wj1fr9Y2Vyduy8jGsibWcycT67bfvz8\/PT8\/PT0+sPA2fnoZDfxkOhsPBMB2D5aTcYgqeYnkOMprDOAKw7Sn9WhgiMc\/0Ar6s9RWOxWdkzdYRJrEFonDZvtSlGIYRSn3NZrPZbNaDVKtnz5+c9VvHhDoFUzSnfBbrGIf30zRNhHEmqtbIxmM9GuUQEQjnWO+eqCAAaqwksHuiqifdlCsZhhEa9XDr4\/GYDCgZUP1mhBCOHyN9HtZs3R8c7XabTzebTTZhWRbGBEKUyNZK8rwVU64+z3qn0yGEtNtt\/WaEMZHWw\/itc9OU0nq9Tim1LGs8HmNMVFVdZMurN9Bq0b6q9dB1D8YEE1Kv1zEm1eoZKwjhpNdN7Z8VAEChFqgrP7fXdmG2IiuPW+OtV6tnnU6n3W43g7ADx4ZCKazzqpf5ndm8QT3pBtbyfCOkemsElp9vPXQdHe3X9ZuRE\/SEYEJ6vd6i6\/DrsqIoilK+5lUAAK9mx\/qt82l\/rGNM2GU+GdBq9WyR9Zhu3WfVmXRzQPdEBagRb90f68Hl01i\/v783TdM0TUKofjPSb0b+NwUhWiT+uqwo5fK+6\/liX9nfV76e9dgMb1lWvV7nA6Il1r1gdBWFTwXmMxj4S6wHl59v\/TEIxqTX6wUyFiHsfVKMMCbtdpuJf4zluqwo5euLfaV8\/fj4eLGvlC\/KCquwuAcs9h\/9DaH57rre+9+\/eAysEF1nzjY5H7FuRw\/c6ekpIYQdI94jslfeNWKMk2Z4FqLzA7SBAEgU68Hl51s3g0QzvGOdUkppr9eDCEGIIERmLK0ShKUWezXPNW\/a+eMtY55rQDtnVaCdh6uRbfpnJN2mx\/qtewcIEzZ8G4\/H1eoZGVCWJE9PT5OO4aPaeUoHvMNXT7q+QV8Dgaj18PLprLMsZZomGbjWMaIIUUoRhhgTiBZaN1slqJ0zBfw8CGQvr8nnzV\/lDb7F+byk29yKdZbVeV\/O+8U01rnvBlowmguM9lSfb7ZWoJdYPJp7CMKtM+VkEOjCxuNxr9fDhECIHmJhPthfCDXdbWmVIND0uDV0DQDfLLeqawCWWr5tulsOtCTb5sPDw\/qt8xG7P6uzofupy1zrmWIYRj8Ic8yVE+JaR4gieH9\/jzBk1vuxXB1CeHjFJoCmey287s66OoSALwoP9WD1Stfcxfu6BqJbSLLNK2+\/1m9dVVUIUejVP8HYstEkLLFOKCKQX6SYptnpdJrNJhvJL7Ee06Jrbipm9atD6K\/Pq8Y3Jdvmpqx\/agzD+DsIG6WzezWsONYRpAi2222IILP+d4acfQPfzlKtIa17GIbxVxA2UisUChAhVph15y6N24VBiP7aNmfffLH\/06\/pVpbWPaLWozDH0bKauqyQ1j0Mw\/hTDKR1j00+sPQV+P79+xe0LlmMZVmO9f\/891IWQcrt7\/\/zrL9vkv54ttHtJ6c\/nmUdbBlj27a0LhzSuohI6yIirYvIdDqV1oVDWheR7KzfHavq8fGB87HDweX7+\/v75YH3QcTBJVvm4IA9KHd8eexM3Dmru09fsIZUe5L1Yc+YTK27stkZcBeaqx7f3R2rTKp\/Qj2+868QXTfBnmR92DNmNptlGet3oWkvggFg1nm7f8K\/WPpwl9Z3yvrlAQhG8CLrByvvrrS+a9Zdl+wEmGf93ac9\/Rkgre+U9UCCX2j93Tfyk6O51GRnPTukdWldRKR1EZHWRSRgvT+eCVKyPuwZE7C+2tOWKZ7LBGAXXrM+5tkTtr65vDoajfrDl8zLaDRaelC+PFu1DgDI3LqMdSpjXUxkrItIQuu+O+QfsB5vghwpAICC4bbclnIA5I5asUvmjlrsVcb6B1hqnd8aX4P1+FgnR0puzxPJToKNWZexTncl1nNHpcJeibz0hy\/9WlEpFOO9ylhfE1u1Pj\/Wj1q1ovLLbX\/4ohf2SrWIXb9v3s6yAgAA7JUIW6ao5QAARV3G+kJ2JdZdl4YWtRtv\/baUc9MDbwdui4z1hexMrA9vS7miXiuCghGTyaPWvUB3w72WKPPLWKc7FOvDl9Yve0puT6vF9d\/x1oOZPFl\/L2Od7lKss366qHsthsa91oogJsMDrcaH\/UU9mXUZ63SnYj02+p38zS7twjnA0MKjORnriZD35kRE3ocXERnrIiJjXUTC1jf30JKM9d1hq09QjXbg8SkZ63TLGT7rN0sppTuyG9kym82AZUnrYiGti4i0LiLMukXnW\/e+NeRj92TnHu5uJQ\/8v9fUreQByFe6znS+0mWv4dpqSOt0qfUP\/Z94cuv5vCeSnQSxXqX1NbE81v1nQOp\/FU9qvVJBrskGyiMU71VaXxPJrW801ivdhqO9gfKVRsSu3zdvZ1kBuJmhW8nnEQr2FlGkdZrcOv8SqE1Zd1w2UNQujbXum83b4zuGANI6TWj948qXW6fdSh41nF94TGDdC3Q33BuJMr+0TpNYX4vyBNadUR1qxPXf8daDmTxZfy+t0+XWLw8+\/v8PCa1TLpJne\/9vtsZkeP6Tr5U8QA1pPTFL7tL4v+ITrPB1T6msR1p8w7V8zGjO+8lX39X8sjcsrVPHuvz0RTDkZ24iIq2LiLQuIlt9girrN0uptE4p3f4TVJmT9QHfCQLWs94ZyZaQ1kVEWhcRaV1EmPUpldZFQloXEWldRGazGZhOpXWxkNZFRFoXEWldRKR1EZHWRWQ2m4HJZDKdTn\/\/4\/\/TADPJV8W27X8BIoU7gkegWQ8AAAAASUVORK5CYII=” alt=””]<\/p>\n
This time, \u201cMuller\u201d and \u201cM\u00fcller\u201d are retrieved as my collation is fully insensitive. For Latin1_General and AI (Accent Insensitive) collation u = \u00fc, o = \u00f6, a = \u00e4\u2026
\nBut I get not yet \u201cMueller\u201d which is a synonym of \u201cM\u00fcller\u201d without using a \u00fc in German writing.
\nSo I decided to use a German collation to see if it could solve my issue by returning my three forms of \u201cMuller\u201d. In this phonebook collation, \u00fc is sorted like ue, \u00e4 like ae\u2026<\/p>\nSelect name from Person where name like 'muller' collate German_PhoneBook_CI_AI<\/pre>\n[img64 src=”data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKQAAABMCAIAAABswIv5AAAIRUlEQVR4nO2dTW\/juBmAed8\/kB8whzks9kI5qHopMNnb7vS6l1EMFwhP\/RGNvQvklNwC8OZDoMSoenGKoIcejAWK2BaT7G6LsYHACwyC2XGUZGqlg1iyA7w90Pq05MgaJ7JjPiAckiIFWk9eklKEGdTp\/MpOThg7YexEZyc6O2nqJ02dNXTWaLJGk9UbrN5gx6Ok+1PdSQ2emqPU9NIE9M+APchHh5uPH29uUqcZ8nHm\/DdELxbTNE3TRHf9Pjw7NE2L\/+JLimmaqN+3slYze7RlQshelsie4ptOkE0oi0yYhNMTi0yCpmmh5axWq9VqtWqQcnkvvOwtGlP9WqO+FSubMhglCiQmLYpsSsPjNAyDUJqJoRkyM9kPxjQmDOMY2ec7MgpAjlJ5O9+R5Z3zKTtpmhbauLqyTdNk18CuQW32CKGz3yI\/LdPJtiw78nr5Q0HXdTdfq9V4xrIsShnGJJGkVM68jlN2j5PdarUYY7quq80epUzIHuGX7QoGgGq1CgCWZZmmSSmTZXmSJK98RNLFdlrZoZtcShllrFqtUsrK5T2eCKFJb5L17yWEUL4SKEvf6zO7C0\/JlLLtaNnl8l6r1dJ1vRaEXy++u5lCtlv0pvfRYbdC3jkP9PI0EyJ7PQLt42VfBxlfs9VmbxTijFHGOp3O9QQaJUmSJKnUcIsIIbeYHTOT7eb9kU0p449j2DWUy3uTZEcs2T6Zo6wT8ec7MiJH0bL9kR1sP43si4sLwzAMw2AM1GZPbfb8XwpjMsl3oyRJpdK6o\/dgXVpflxZOth0jO3IatyyrWq26e5wHZHuh55gJ\/wZwjcEwf0B2sH287KsglLJOpxOYnxjj3xMooZTpus59X0XSKElSqXGwLpUaV1dXB+tS6aAk8QKPcsQj\/cpfETru9PW+\/\/rBVaDDeJ+Yc7rMRvbu7i5jjF8ad7Xjn+6yRylNOo3zgIwPxyOCUKLIDraPl20EGZ\/GR7IBAKDT6WBCMCYYEyOSehHjYp1\/GvuKlx\/98NoY+wpS9nkRKfvh4tg5\/QeSntNjZrK960IZ35GZplku77Fr4DPh7u5u0t34uG133kbuYi7vnPv2cUcEjcsOt59ONp+TDMNg145sSoAQACAUU8owmSjbqBexss+vvKs\/MFd5VT5d\/qJb4WvuHkt6zseUzadud51217xpZLuaj8iEDVpgAyf7NPNegaVg8gbtMogrm5tm14F1yjTNTqdDGcOYXEbCNfCfGCuqU1MvYqSoUT1UBSHfIaeoKggX675zOmcO1CQ75+Xl5cxku3tv\/9TNN+G7DrGyM0XTtG4QrtY1zZgjmxAg+OLiglDMZXcjOd7EePOYZ5CiejVu2Tl0vImR2xRvqsHisao4zbuqgsbPkOScx964ZiZblmWMSejTn+E8pcWEPCCbAWHYvd0wDKPVatVqNb4nf0B2RI2qOPMtLx9vYn85rhhdleycqWUPMvXyKGia9iEI32\/zRys8jWQTDATruo4J5rI\/ZMjeG\/Rmb6oeQjZomvZbEL75yufzmBCeuOzRQxVnncKY\/PbU7L3xRfpf\/jVdZyE7QvY4XO14SmcsK4Rs0DTt\/XIwmw3aQvOYbwEtKqenp89TtmAcy7I82X\/926FIzzid\/fTvgOz7x6RrDh\/1\/MnpmsPsAiwzbNsWspcFIXuJELKXCCF7iRgMBkL2siBkLxGZym5vy\/L29sboLwAbh\/f39\/eHG97fBDYOeZuNDf7S2fbh9ijTHnV3XnLgFVONJNvrnglZy3Ycc\/Ht0FF5u93elrlLf0bebvs7jPdNMJJsr3smDIfDjCO7Hcp78YoQl+3W+zP+ZtMHt5A9D7IPN1AwXifJ3kg9XCF7TmQ7Crn3ONn3PtvTixey50F2YBafKPvet5kTG7REZCo7O4RsIfuZI2QvEUL2EhGW3TWHS5Kyve6ZEJad\/D3FdCCE5uEz24ueFRGyH2\/y7PV63ZvbzFOv15t8UZ4rTy0bIZS5bBHZACKynzsispeI5LJ9T60\/Q3a0ALYlIYTymlNzVswhlNuqR7bMbdX5p4jsKUki231cPQPZ0ZHNtqTcquePu3802SKyAbKN7NxWMb9aZLfdm9tupSDlC9E6RWR\/Bk8tOz6yt+qVgvTDWffmVs2vFitjUv2a3Xo+ByCE0GqR8TYFJYcQKqgisseYo8h2FGrKuNRo2WfFnDMZuPXIqRGRPcY8RfbNWTFXUCsFlNciputx2V5YO8FdSTS9i8gGyDyyb27rP6xKuVWlErU2R8sOTtfJ1nIR2QDZRzZfgwuqV6Mprs5KAUVM40ipuBv4gppMtohsgDmI7MhYH03S\/N4sHPGaEt6giciORTxBS8PKyot6Yx7\/s4zJiGfjaVhZefFq7fXC+RaRnYaVlRcAsHC+RWSngcuGRfMdIfvx3gR6ZpHNWSDfT\/1aUu9ZvJPklw2L4zssO9vRLAoh2bAgvoXsNIzLhkXwLWSnIVK2ZQ\/n3LeQnYZI2QDQ6\/1vnn1z2aN\/lVjITkicbADodo259S1kp2GCbAB49+7i1drrJxtMcoTsNPhlf\/rU55lXa6\/9KaOhTULIToMr+9On\/hdfrBz+\/Z8AsPb1H6uH\/8h0XA8gZKeBy+am6w325Ze\/A4B37y54Zm4RstOwsvLCNQ0A33z73Y8\/NnhmnoNbyE7Dq7XXrmkAqDfYy5cSALx92\/7qq99nOrRJCNmz4Ztvv3v7tg0AGP8h67HEImTPhvfvP7x8KRX+9OfT01+yHkssw+EQ3d31B4PBYDD46ef\/DAIMl5bBYOheBdu2bdu2LNuyLMuy+v1+v9+\/u+vfRcOP93lj22Eerqlt2\/8HFExEVrjMPCIAAAAASUVORK5CYII=” alt=””]<\/p>\n
As expected, I received just \u201cMuller\u201d which is quite normal as \u201cMuller\u201d in German speaking is not \u201cM\u00fcller\u201d\u2026
\nLet\u2019s try with:<\/p>\nSelect name from Person where name like 'm\u00fcller' collate German_PhoneBook_CI_AI<\/pre>\n[img64 src=”data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJAAAABPCAIAAACLTNsVAAAezUlEQVR4nO2dd3BUV76gqdqq3dqtfbt\/bNVu7bzdV+t58+Z5xh6bLByQ8dgGmwFMRoiMMiCEhBBKKIdWFhICRZQDykJqqVsZ5ZxjK9FSp9s3h87d9+wfLZIRGGnalmH46leqvveec3T79\/Xpc3NvoBUqtUar1mhVGq1KrVWqtApjKDXMSqFQahRKjVJlDLXqtbFWNGrN69BqtTTNDA0Ni8VisUQiFkvEYolILBaJng\/Rkki0JHpTln6GN25oFYhfBoIg\/DmIFyFJcoNaowVvISqVqrKyksfj1T6hrq6uoaGhoaGh8TkaGhpq3x54PB6Xy0UQhKIo4hW8IAxjNKNCfEyIjQmxMRE2JcamJdj4ItY59iw6xgic1q2jKiMKhaK2thbDMJIkjR89GIaEwsezs7MCgWBmZmZmZmZ2ZkYkXDQW+O1DkiSCIDweTy6Xv6mw6gHxmXtDN4rmXQvnXZPmL8bPWyXNn4mbN78+b3593tx1fteN+T+cH+T3oeuoyshPhCkUTG\/veGtrT19fX3d3d39P90BvD5fHzamqZBjmV0z72jEK4\/P5qxBWMyS5eH\/yFhfyqoR8UpAzUfJdHtAud\/keH\/QbT+gbT+iHQPhTy9n6VuKlBCoXeyvjI0L8jQRy+FMkuyoDLDzU0d0voFclDEVRgiBwHFcqqerqqfHx5U8SBQABQFXvbEh6qYKm8bcBgiBgGF6dsNYBSdSD0eJOYUmnMLlmoLB9NqFMGJ4j8L7bE18ijC9Z9Eqc2Pplfm3N3EsJFOZ5nfzLxn129vb29vb2J7\/cd714htSsQpihJ\/DKzaCE0lp+54SIekNhCILgOI5hmEJBVtdMzkxhWrVySfS4fwGqntGF3hsMDylVKCjsdaAoRiq0LABahsRRFMVwUqUHQKckXlvN5OA4LpfLVyest1s83C8zvp6dHAVACwAABsXUWI9x5twUtm\/v5eoa3ksJnM3kBPokTjyZ7HM3dysdh1chDIxEuoUmpcZcvhxR3v\/zFV8WVl8rKHw02dTTUZjf\/OBB+f0HtSEB2SHBJVoVxRAESeAYhqEo+lKeKCUxU5foY+Nx79G0XKOgMGSmItrNM65qDsUJ\/LctbHBwur6+QygUjo2Ntba2Dg4Ojo6O9vf3PHxY39g42dHeWFY6cPCgPY\/38KUEzmVx\/D3jBpandPVXd\/vUzmMqYZXroQMHDvzoHF4hBgCIG8KuHT6w\/8ebBb3S2dake\/USLQAA7amtLC7Oj4kIvHjgmx1\/\/tMWizujsFLUGHr0wI8\/XnQtnFihpxqFyeVyFEURBKFpnM+b4nXOzYtFswJkdnZBIBDkcHsKKzp5k1Dp5OjI0mMSR42FX4BQ6JGOMOtPNvyXvXeqBVpWBY+k7f6nDf\/5C79+jCDxJ8aMFZ\/6RlEEeWofRZ9f9KzsT+Y8m16efFr9SXmZTLZaYYPt7e0kScIw3N3dLRQKYVguECwWFfULpoQjc4sVTcOHD1rU1FS\/lEBxedDpD\/91865du3bt2vX1Zxc4NeMYM1d047xbbEFBQfxNp1ux1Y11IX6ONr4ZeW77P3NNyw86aJEwqQIALBZE+bu5R0RERdxycTi2\/5TznUYR1hP514u+mff8bE4ePV8kegNhNTWTvV0LGjWjVimEItAo0PMmlJRCNY+rm8ZEtleTS4v5KhX9U2c4o5O3RHi5frvxbxFF1fO0DuG5mZl\/bXYgZhjFSZLAcQzDcRzHMBTFng03GIpiOEHgGE4QBI6hT3TgOE4QOIo+WYw9KbBcebkx43Icx3CCwHEMXaOwnp6Frq4F4+uBoUGGYQAAEIQ21ndijGpcCRoHBYd\/PFBTU\/NSAh8XhLhY2t2uraurqyvz+G6TR+mwZDxv3\/\/8Xx+b7969+6tP\/vjv+92Ts2M99v\/ps2NRhR1tgrmuBItzydNqAICo7G6En39MaGhsSlqCm9sd3jgJwGTozj9\/duBoUOHgxPCSciVhfD4fgiAEQWAYpiiMx5tubBwfHR3s6ux81Nybx20umxECjAAVKeP5BYn32+3sQ0pLGigSN1ZZBqO1UHPQdX9f27NXEnNqx7Hu8FNXAh33W6YIsMcdWR7fme3YYWbuEPFwhtEulAcc+Hr7ti2fOaQNoMKRHM8DZmbbdhx3LR5RzZZ7nvjGbIeZ2Y4vvwqqFNKUtCfX45uNmzdv3rTpi\/OxPIFS3uB3Yo\/Zjh1ffGefO0ZQwv60G3vNzLZ9ZulZ2g+rKAxBEKlUusoxrHeovLx6bGysr6+voKu3prm9smKIV9OcmdlbUNxbUMbNLyo7fOgIj8d\/KYGzWRx\/z\/hB44S+LeC7m5ltldFH\/nQuuXdscnJiZGBgYkYkkc6PD44+vH3x8K6LiSURJ8\/cXwAAAPnDu2Fe\/jEcTszdhKhrztEVgzBgmcXx\/qHO6gCLnRaOeY9f2uI0CpPJZDAMy+VykkS43MnhYalSqSBpRsGQizBUKpgEahWYn1AJH0cW5X7y9bkvPnfs6R2laUL+FJTSyBoDnDw5YQGXHENSK3P97PwzU7wtbO7W1aV7HD3smVHDzwuwPHIlqqww4sCFa34xaQnulocCs4rjbbdevMtPuXHU2iW0bgGfbKkqLSnMTw213n8+qb457eYRc9eMvsGmexcPW3mlcYv9L9q6BGcUlyT62x+yiy3Ji7HZbp1Yl3ztRxu3yLolLY3DsEQieZP9sGcjRFdXZ1tbq16v1+u1FdWjj4VSklJMCeYKyhu6BVpejyqL27pvr211dfdLwmbSAz2cQlsMy5Pd3l9eSuaXRtnuCS5fXFoayPMNDeckxftdvuyd2zPSFHLcIrwo9cZOt5zhqanxap\/Ltuf8okICwm\/fjXa29YwvHIBmSxz3nE9on6xL8XE8d6td8SbCJiYmEAD0c4ROSii7IVXJ5DzAFkCKH2gbLBu97x0ftcc6sK6jg6HInwq74up\/vzLXwyfK49Bm9\/Tq\/HCrC6HZ8bYf\/tfffWS2w2zbpj9\/uN0xqSjp5qldmzYfupXe3Dk11vfAacemLftPB6U1T84uyabLPY\/u3rp9++aPP\/zo+5upqd7HziXOagGg2oOdvUOjwi5\/u+mf\/\/Dx1h1mWzZ+tG3P5aSKHKcdm7YcPM\/JaJkUCGU4gqxJWFdHRwfL6lQq9lFz\/+MFGUqSHQJReVlTS5+2sBd\/wG8\/sO8ql9v7krClh6l3ItMHnwiDym8eia6fly5UumzZvHnzpoMOCUNKlWooy3bfxs3bzU5FNyAKzUiy1ZbNmzd\/abbliGtGRl5qUnpeU0OB28kvNl0qmxX1pNls2rRl2\/en4ltQ\/St6mFQqlcvlEAThOMzljo+Pw3q9SgRjwzjbOgVKK2YBw4DhHsPSgkA4XDTetvdcYB2vg6YJ6CkIqZY1Blxx8Ununed7HNz0ocW99k7enfPngtLCHb\/\/\/BoPoQn5\/OCj9p6+vq6O7uHJmcJbP+zccj69r7enb3asM9th+8YL4eGeJ87d8K+YoakZHufgcd+UZK8Tp6PG1QAou0JcvEOiwy7vOuSS3CCkCOnscFtt+8BIb1fP7GjbfavNH5\/yL51WKQi5XCwWr05Yf38\/hxMaGXnH3T3JxSXf1fX+zZthnl6e7u6RLi5JLi5O7u43duw4VFXV+pKwV2PQ6\/XPJ9zw\/KRB\/5OlAADWYDCwT5caVt7\/NgqTSCQQBMlkMgyTc7njk5OowaCcwNg+iaHwUXspdwwsSQwcbwUvv6QrLaY2bf9JTm1NO0XhsqfApFpS62ntcD3mEY7U+Vr4FXSMDNaG7j8SXd+W7nt2t3N0Da8w2Gbf1cjEe25Hvj96LSIxieN8yio03P3A9v0+BYUh9lZeMeFBp50dnYJyKosSnX74398H8dqy\/U58diG47GFu0Kn9Vr4Z9dy7lhdtfJLyS5L9r549wbmf7LbP7KB\/YVGg9RnXkJwRWIHDkEgk4vF4MAy\/qTCRSBQRwbGz83dy8rp6NdTJycPRMczZ2fnaNa+rV0NdnJ1cnJ0vX740Nja6CmG\/DCsKGx2SSCVEp0jdMA37dDqV13ABCYPWYqz3UUlD0Z0U7v69IbW1LwqTo5SkJyMuIaWkR0aTOIETiGSqLcfXv3iGgSbq7lmb79y58zvneO4srRfyIk7u\/eqrXT94FE0SS+PFwRZfmZvvtgviTqiI7jSH47vMd+403\/XdUbe8OQKebU2xOXzk+B6z3\/37bufsQS2YzrA\/sWvnzq\/3XyuaxMnFoVy\/Y1+Zm\/9wJZw\/jjIoJINWL+wtwihMLBbLZDKpVIqiEJ8n8I3Jc\/W6fTH67pmURLu7qTWNLQCXLnLsBEUZAWkZIXfvHz8SyOO1kSQmfYpEIpFCKIahCCSRSKQyqVQqlckRAkdkEikEYyRD0zRNYLBMKpHBOEUzDEMTCCSVQQhOMTRNkzgMSaRylKQYmqYZRqFSIgsjdal+gSERMXfcz+6x8UpoFSpxFCUpmqZpmkAgqVQGoQT9pLpUIpHIZLKlpaV3VphSqeTz+SKRyJhzCJKOjSxFZZdF3osLTkr0Tk4OTElOSc4MjCg\/5lty5MrdsxbJ1hfDNm48w+N1kCQmeXOeaF1xcoVlUhmMSgS9xf6WlpaWJy1OW3EyGmZRUi5dubb0uYnFxcWfF6Z5m4VJpVIYhpe3HlC5kiaVCoWKYbRKpZIiGxraQkIyo8NzYqLyY2LzoqML4uKKp6bmMAyFfmFglFTpl1EzBALJfr4KDIvFYj6fj+O4SqVSrARN02+rMJVKVVZW9vSk5UvUNzQ0tLW19vV1vhhdzc1N9fX1r6i1ztTV1RUXFzc1NbW0tDx6kebm5paWlomJiQ1a7Vt5xhkAAEGypaVVXQbwG2dJJBJJpdIVr1BYXFxcWlqCIGjD+MRUY3NbQ2NbQ5Mpo9Gkra3Yfmtbd2v7P0q0tHW3tfdMTc9sGBgclcsRGEFhGDFhzC3BMsiUDa45EAQRSuAlGYqi+NsdGE4Q5IaR0QmWXd3J4TcBV7J6w88X+3VgNKxy\/S9DMQF6vX7DyOiETqczGAx6k4LQOo1Wb+JG1wRr0JNKHa3+zXx8\/g60Wu2G4ffC3h7eC3vL+NWE\/fQfsz+dtfIg+tOaa1qT98LeiGfCDAaDAZ0aGeeXFmfFu7t7+BR0LaoBmK4O8\/Fwd3f3DL5bME9pZkc6i+\/fi\/Hzjqvray9KCPX1ze9HAADkbEO0h7u7u28mf5wBgF39ar5zwkZ+YWEsAEBYcMty2ye7r\/ldu3bph73W9zoWqOnqiMDAwMDAGzbWthFZtakeZz7fetTN5cSX5kcd7Bwdz37zzdXSBdFkRYCd7c3AwMDLVleiSgdlALDsP7AwnU73qwhjFwv9zh61T5cDAEDb1VO+D7plgJ1Kuenk4HBu\/9f7T7tF3\/FzvhLUCcCU9wGbuHqJDubano3hVoR+\/38\/+O68g4PDkU8\/+PBHj0oEALBKY++FrUHYbG5U0I3IThYAAFc7Xgguaq\/NtLe67B6XmhrnZmvj4B5zO4bjnzQGwKNrVpzSPjE1l2d1PqI45Yb5708EpKempqTnPihuG1uiDKte0\/fC1iIsJ+yWY1CTBgCAcK+cC8ptzHT9+HKJBABA1yV4HHGJvB0R6BU\/CMCjq2f8CzqXyJmss+fu1NUnXT90vAQGAGB1UYlJeQMU+\/4r8dcQNl8QHega1qIBACA1zjZh5T2Cjlirbdu3bN36yR\/+3\/YT\/vcSb3P8E4cBaLthE1rcIyJnc8+fT51Wy0cfeh7809atWz\/927noJiGuA6te0ffCVilMr9frNRSOIbhCr9frtQwixxmVXqeUCSbGxsbGpwRCOUaSBI4RKr1eicAYrdTo1JQcIjUAsDp6aWJsbGxyCWEMAKxhLd8LeyNeFGZMFqvXP7mohjWslD92+Xoc1mCsYXjxGpy1reK7J2xcr9exrMFg0JswEFqn1elZk7a5tgCsnnqXhA2NjCvUepWWVWoMpgs9TBsAAMYOYzxcwT45nmGc1LEAAGA8hv40ly8X0D83\/2nJ5brPFVix7tMD9GoAKNW7ImxweBzClRChgnClqUJOqsUwlZb9YGBMkFtU0dk\/VlpVV\/eoq+5RV2llbWf\/WG5RxcCYIKugtG94Kr+ksq17qJLfVF3f2tTe96CsumdoMvtB+cDYTHZBWffgRFFFTVN7H6+xraKmsa17KK+4sm9kOqugrH9UkFtU0dE3WlpVV9vcUd\/SXVJZ2zUwnlNY3j+63HhBKbela7DoYa1aa\/pTSL8+Op1uw9DwGEngKqVCoWBMFWqVSg5BwaGc1rYO\/8CgGn7t7bg7OXn5OXn5Mbfjavi1AYHBj1rabvn6NTY9Cg7hVFRW3UtKTr2fXlRcGhYeWd\/Q5Osf0NLa5uPnX1vfEBEZXVRcmp6ZlXAvsaKyKig4tKm5xcfXv7mlNSAwmFvDux13JysnN6\/gQUxsHK+2zi8gsLmldbnx0DAen5+VlbneqTYNOp1uw9DQKEVRLMsaTAfLsgiChEVEL4jlagPAaA2tNhBKHaHU0WoDRmsYLUAplUILUErNaADOaCiVgVTpcYWW1rAorVY8KYDRalrD4gotqdRTKgPOaBgNQCn1cl0twJgnjSt0tJp90vhyAQMAlTW1RUWF651q0\/BM2IpbiWvedDQYDCiK3k1KnV+SwYRChlLPAqMhjH46CWE0hL2w9Mn8Z3\/\/nsAV6vqmFi63ar1TbRp0Ot2GwZWEGQxPLhtYkzOWZWEYdnXzECyIEFL5NH1SlMEUelqphjFKilAyTImrDCSjlCGUnFQhpBKhVAipgDAFzqgQUoUzSujvE0aptQ+Ky5KTk9Y50ybiVcIMLAA69VC6XWKriNCzqz6nYTAYMAwrLK14LJbLcWY5fbiGggcTHI99cTGuZY5g1BrRfHvw+R\/PhvLFWlV3fvKd5PvJt+OSHjSPCZqC\/dIrqjK8g8rHEVr+XI9cbaC0srOnv729bb1TbRpWFMayrKI13vbbrf\/2P\/6jZcESya5+j5VlWblcbmNrPzW3+KyHEXqltP7q8c3\/9LvzD7olCoNaUOv\/hw3\/6V8tMxb0+qXpib6h8f6BsZFZqXA4\/dgBr8QU733H4vtgGqFUKK3GaDVCMDKUhkklQqlRSil\/A2GMVpeRnRcVFbneqTYNKwozGAw6UjI71J1m99G10nl0DQeEDAYDjuNcXt2iFHnWwwidQsJ3tve2\/Ov+sLr+RUwxkW\/z8TfHD1lljxOkGGFQRo1RSilCCQfun7YISMsIPHY2eQhl5DA0MSkYnpifkxBynBSK5XNzc2PTIiHy88IQStk\/NDow0L\/eqTYNr\/xKBAAAtiNg643SWUS\/ph4GQdD5C1aTs8LnephOIeE7WQXGetmcS6huG12s9Dp+KTjA2i4iIZHjElQnZllmscbZPiwtI\/zceU56RuCx8xkT8HxN3JWd27\/43OzzM4FVo7MN1y\/aHTLfsvOvXhWLuJxkXj\/IMVpdWkZOWBhnvVNtGl43hmkUTbc2u65NmHEMq+DyhBL4xR7Gc7roG58aY28VllWTdtU6POM+x9Y+NCrS29q9SgyAQlhudfJWQkrouQuc9Izg03YpVQ\/v2O3ZfzOTy80LPPDd+VvhASfND19PaZuQvtEYhlDK3oHh3t6e9U61afilhBnHMIdLV14cw3QKCe\/qBe+4hx2Frk7uboc\/DyrnZkfZ2oZEx\/jY+fCkACiWqi6d9U9M5Zy7wEnP4pyzjsqIsfvjf\/vjtq\/NP\/\/8q13fWQTG+R0+GVbYtYRrtW8yhtEaXVZuQWxszHqn2jT8sj0sO+\/BC1uJhE4h4Tme94p\/KJiudPz8j+ZevOn6wljrS2G3w3wuOfMwAIC08swpr9jUsPMXOOmZoWdtb2fGuh761r0NAAA0w4197fx7p84E5rUuwErVm2zxY4yqtaO7ublpfRNtKl4rjKl1+cChYBpeWw+DYdjrlt\/MY\/GzHWdCrxRXWh1xCisclcu6Ym7kd4vna7N9D9qk1JUk2u06aB8SEuR69INtttFpQceP+SYlee2zSG6fqIq+\/MNJO06Yn\/Wh727Ep4UfOu6d2TQHq95IGKnSFpdVpqffX+9Um4ZXCjOwrFY9WxvPHYWZte2HIQgSFRs3tyh9JgxX4dBYQXZlbe+iXGlQGABNoiOdvNSCEal8uujO9XNnL5y+4eETUd7d3ZiZU9fSzkvJ6ljUquf7K\/0uXjh97kps5bgUE+Td57ZNyuSU4k2EEUp1TW1DaWnJeqfaNLzySIde\/+Sk45rOGhoPTcXfTXzx0BQpxVSURo9TjAwhZSglRWmE1jFqFYSpKB3QAaBjgUZvQGktrdFhtI7RaCCEgmmDCgAdAAqVGsJUtEaPEYzsDbbpZSiFK9S1Dc0PH1asb6JNxWuF\/R0YvxJvenj\/5NDUrx+UWltYUpGamrLeqTYNz4SxBoNBrzdVsAYDhmEFxWWLMhQmFHKcgTBajjNPX6z0l4FeW+C1dV9ZAGPUXb0Dra0t651q07B8tB4nKITRI7TOVIErWYkMumhtMzI5K8eZJRkqluMiCBNBmFiOL8lQCUw8\/9c431jm5QLP1xVB2Ip1X9U4qdIkp2VERISvd6pNw3IPw3ECJ2mMoEwVOEnTNF1VVWVpeaqKW+3s4pKRmcUJC+eEhWdlZzu7uFRWVdnY2PL5tQ4Ol8rKy909PBOTkuPi4\/38AwqLii9fcayu4Vnb2NTweI6OVwsKHvj5B8TExKakpLp7eFZUPLSzd+Dx+Ta2dpVVVdddb2RkZkVERIaEhmbn5Dhdc+Zyq21s7YyNl1dUHD12bGFhYb1TbRqMwkYoitLrdTqd1oRhfHSfVCplGBqCIJIkURRFUZQkSQiCGIaRSqUKhUImk9E0LZfLCQLHMQxBYJqiZDKZYrkAA8lkFEUhCIxhGEEQcrmcoWmZVKpQMFKplGEY+dPGEeTlximKkkgkhhWv0XoLeSbM5Je50TT9S9yJuwYMBoNS+fIDF99KXins+UJrFvYb+Vyr1ep3XBgLgFbYWpZ9P+1+TsUoBgC7hu63sjCWELTXlrdO4BoAAGB1xFRHXcuI5OduGGeWZmdnZuenp2YeS5nVvsl3XJjBwGoetwZc++H7PfsP7t+19bhrr0i3hhvpVham6fb6279s+MDx0WMtAICZztnz3\/\/D7y\/kkz+zntOpgQF+gWHuN\/xvF02t9k2+48JYllWMFAfn1S3pAABI+fUvrXMW9Oyqja0sTNXh63L5602nSkaWWACwBrff\/8u2by+Xq35mPQWZYWGh4bF+tzj3yqZX+ybfcWF6\/XOP19CIy93MbXNNKKzV60p0xKWT3rwBiDTMpFkedbt16Wp6a09TVeOcAQCgnnlY1DgqUgLNyL3rDtbWNu7hDyEgKYgMCw2P9fPhJD5cAGA+18\/Z2tr6qnfWnE63NNGWFhfp7+CaVDOjXulNvvvC9PrlexLE\/Fu7vj1dMa9ew2UdrxLmeSk0N8X\/om\/uo\/G+LKebydkx167F3Iu7ZetVpwMAkFyb4945beNdKW4unhEJCVFerr5xuZWZd6LCwmP9fCKSa8aGCv3dbgTEJyQEuXsEplRXxDuY\/fmAe9id8q6lFZ+a9Q8gzMACAOCmqB8PW3H4s+o1bXW8UphDcAafn3g5ICPX\/QfP\/Eelcc5OMWnJoS7BzToAAFXvYhNWWJlmv+2Pn3570MLiyNdbP\/rim7PXOQkxkbH+frHpBdme33\/60RffH7ew2LvzL3\/Zctwr+Jb11bLXfKm++8IAAFhr\/NETNhye8TdWVnvP42uEtXjYB2Q+WhRkOVge3HWheLK\/6t61q9GpiSEuIa0AAKBsum7LycsNs\/jkhEd6UXV1Db+2oWeg5nZoVHhErL\/\/7fT7UbafHb8clcmtrubx6zu66rPuchz9Gl+znfmOCzMAYBDkW2zeY3mnXkoxNI5TSq3phDXfsPJJaxDphBmWWxwrF2WD1XG2bskVaTFu51KncBwfTtpzyC35UVOy7e4grphl1eNlGeE3I0PuRHJCom55hSVVNOU47\/XM6FewrLS1IORyVNz9QHsP3oqjl5F3XBgA4HGZ0xcf\/J9\/+8vGzZs2frrja\/eyBZZd9UnMlYWpO4OuR+Q+WgRAg0kpLaDGeHev+jZgknaO5baPN27cuPvL7Xv9G2cINfHQzWzbxo2ffPk3j7qp8aKkhLj4pPDQ+My6RQ3dGrLH\/JONG7ea2xf2TdTm33YLaXrNQzrfcWF6vV6jIAkMlsukYrFYLJFitMZkPQzo1Sq1Rvdsvl6rVqr0ALBqBoVkMhmKkbTKWE+JymUyGUKoAAB64w9jqtUaHQsA0BAIJJPJMYYFwKBVK9Wv2\/N+94X99Enxa3j6zPtDU78Mz05gAlPfMvte2C\/B8glMkqQUGpZRG0wYFPVbOVqvVqsVipd+u+XtRKfTbRgeHkUxHCIUEG7KwHBCpVSqfgMolcq390HUP2H5KQIqlVKjVqlNHGpjstadd8YWMAobGRlf79V4z5tiFPaLPKT5Pb8E74W9ZbwX9pah0+k2LCwsqjXP0L4Onal47X9ZAyZbsd84Go3m\/wPjs3poEaw0iwAAAABJRU5ErkJggg==” alt=””]<\/p>\n
This result is consistent with the German speaking where \u201cMueller\u201d and \u201cM\u00fcller\u201d are the same. But I cannot yet get my three forms of \u201cMuller\u201d\u2026<\/p>\n
Getting the result excepted by my customer seems like an impossible task by just changing the column collation.<\/p>\n
Another possibility is to use the SOUNDEX string function. This function converts an alphanumeric string to a four-character code based on how the string sounds when spoken. So, let\u2019s try with those queries:<\/p>\n
select * from Person where soundex(Name) like soundex('muller')\nselect soundex('muller'), soundex('m\u00fcller'), soundex('mueller')<\/pre>\n[img64 src=”data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAXYAAADLCAIAAAD1Hy8tAAAWDElEQVR4nO2dX2\/bRrqHxx\/HV6cJJQNk7vrfH8B3Vbxqq0nrT7GRG8DAaWhdBdBFW+8269SoCiwsVFcHOMYuFkeNeeoCvbBQwVc5bR3ZTqzsbmubgnkuZjgcShTFvyIt\/R4MHHJIjqix+Pidl9SENJr\/\/cnmlw9qj5\/9\/Ov\/\/XL886\/Pfznu\/fr85Pj5yfPeae\/k7OT07OT0xcnpi5OzF6dnL33K2dnLsxe8vJhUXr54mTTnUvHgxUv5BG4eATvBnz4A04V8svnlorpSXF6b8NkEAICQcMUUl9eKy2uN2SXrfgZgThlWjDWLQDEAZMW8KGZ+yPoTBYALVy6mMbuKybqfp8T8vFNwUwgaxdC64VkUOlym6Y6ANBqNoZsue3t7e3t7u262th7Hu5+VPVAMyBshFFM3LF7qFh1Tbopi6vXh8+z1erRez8QLCQLFgLwRPYoZjV8UaijKGMV0N1XigrYi2aK7qaqb3ZAHNRqNoQdMhGL6\/b5xahmn1vbTc0rrmTztkiBQDMgbQXMx8p\/9\/f19sby3t8cWLi4u6nVDUWggNUQyhXNgyMPHKebw8NAwjP39\/e2n5\/W6AcUAkDhBoxhZMUIrlmXt7u5alnVxcdHv9+t1Q1VVPzU46y0aLY6JqpgzN\/W6UTeM3d3det3Y2nrMCqX1s4AYnxQIIas7rvXCJ0bQ49MCigF5I6hitrYeHx4e7u\/v77lhVynLlYZQjFh1BlB8s6hQN7uuoxy5UKo6R7j2H6+YUzejuZjtp+c8nDGMumEcHR2d+vB0vVAoFArrT8UqIUSsZgcUA3JIUMWIZTmKqdcN9jUE49Ta2nrspxiPVIykEL5oRzfdTZXQlrdi5CjGvX8YxTx79qzX6\/V6PcOwtp+ebz89l9+UolA\/yzxdLxTW1+\/aUvnqbuHu3QIUA4AXoXMxcv5ld3dXZEwnKMYJM2wfDHuHycMd0kxQjHv\/8Yo5cVOvG0dHR65YzDDY+7TqtF439vf3mWVOPPluvVBY\/+6ru4X1705OTr66W1j\/ar3AVr5bL\/C3w9adiqHt9rHO+7\/71YnrgNFjxrQpgGJADgkUxTx69MgwDHZBiiwG+ynSGfV6PehAiQUf40OPFiUkUBTj3n+8YnpuRgdKXDGWZVnW0dGRQqmiUEWhPU\/a1UKh2mY\/e09KzjL\/x9mn96RESk\/YKik9GV4daVPeELRNBygG5JCginGuxrrB8rv9fn9r67FxarGxxqNHj4LeURp1jBgZEZGkUTe7Ula4RcmoYob3D6cYFn\/1ej3j1FZMnVqUWpZF60q9bijUVzG9drVQesKudyEdV1zmVEmSkFdFhbS72Ba0TSgG5JrQimGDI5F\/EbmMMIoRcmlRn3SvKx2sSnJhR7kGW\/7p3uduhGKYX4xT10iw3+8fHR3VDUNR6HNP2lVFqbbZv4pSemLXtKsKKT3xOuJJiRBpk736pESUaltq027ZVROszefPn0MxIIcEysU8evRI3D+SB0fsRtIjm7GKyZRGo3HshglF+MUwbMVQalHl2bNntK4wxRx70r6vKPfbbIGUtp0asW5vat9XiNhVub\/tXm1vl+zdj7dLZLSFIG22nfOCYkAOCRrFqKqqKHTop7zAmJo4gjNBMYZFDUXcMuv1eoeHh3t7e+y+0gTFeNRsl3jcxdfb9xV5fdyqd1WwNqEYkGfmYjKHX92we0bsATxWuGKoYlFlf39foQpTzK8Z8pf3yHt\/CXUEFANyyFwo5hc3LJW7urqqUMoKUwx\/9M4eCSoK\/WXaPH5Pimr++I9wB0MxIIfMxXwxEy9OJpTREs0TWQHFgBwyF1HMz\/MBFANyyFwoBgCQCd9\/\/\/3sKwYAkBUXFxfeuZivv2mioKCgxCwHP\/zoHcV8\/U1zkCbHfTPV9iOTyIkd980s\/mAAkDsuLy+hGBdQDAAJAsUMA8UAkCBcMZ65mPhXmv9FmGr7kYFiAEiQPEUxHV0lqt6RVqW1qTFZMQFODIoBgHF1dZUrxRBHMjlRzOhpQDEABCZnilF1vUIqTWc1e8WMAsUAEBiumFzkYtilKy5ge6FZcb4XWGmy+kqFTdmrN3W+0OEt2BNYRZbT2CjGaXxy81AMAIzcRTHMKbZKvEYoImUjL6h6Rz4gRgQ0RjEdXbXDq2YFigEgIKZp5k4xg0GzMhTOyOHDSJgjqUcmomO8FSM7CwMlAAKTT8XYgyFV78gxw5iRlKSYSvyThmIASBCumBzlYvhKs8IDkabI\/3LbjFOMPJaJoZuJA6Whe+vjGsnwlwpAfshpFDNwZ1pIkIHSYCClhtNM96oqohgAApInxeQDPN0LQIIwxfwZihFAMQAkiGmaZH3zz7nIxeQDKAaABOGKQRQjgGIASBA\/xRz3TZTIJcNfKgD5wU8xqc9LTkhuf8Ykw98oALnCLxdzfn4ef8gwjvPz8+OzVzks8QUBxQAgmBDFpKoYQkjmQhkthJCYfQrFACDIUjGZ2wRRDABpgygGUQwAKRItFyN9byiGYrwvcmOjQAhZbdg1B9UiIcWNtueexY02+zm9KKZFCW357gHFACAIG8WIL+okoBjvKMbYKBSXHGsw40xRMeOjmG5NY+8digEgKNEGSilHMcWN6upS1Xh1fPbqeKdcWC17SwRRDAC5J0vFjI9iNto75cKDg+OzV9urS9WdEZXIchH1LN4hhJClqsH2KZeKhJDydjJRDAOKASAEuczFOOJolEZV4q2Yg2rRDnxEPbFrEMUAkBF5jWLODqrF8vZOmaw2PAZEo4pxQhg7kNmJOIBCFANAgjDF\/Km4\/HFx+eMcRTFnr9oPlgrFpdKOV87FWzHuAVHUHA2iGAASJEvF+EYxLLdS3nZqGiUhkZ0y8RgokdKO3QIpb0dVDKIYABKEK2ZRXclbFOMZ1\/BhELurPRzdNErD6V5EMQBkjIhi1orvBldMAuDpXgDmAVsx7348fcVkbpNIUcxkoBgABFkqBlEMADOPk4spIIpBFANA0ji5GE\/FpDfvJKIYAOYBrpjCux97KiZt8jCHZuKzap5DMQDYTFBMqgOlDN+2D\/FPLLdvDYDpk2UuJsO37QMUA0CCTMjFQDGZtADAzICB0jBQDAAJEloxzYr9ZeZ4XyEYex2yueWcZ\/S7NY0Qrdbly1qty34OryWFjyBa1H7vvl8hgGIAEITLxXR01TaLtJi4YjTNsQYzjqdEpquYbk2zzSIthmkBgDkkei6mo6uq3klHMbUatbXRohql3hKZehQz9MpxWgBgThADpY8K734URjGpRjG1bos7pkW1WmtEJbJcRL2YvZuIYRSl2qRRzQgBBIEoBoCgRFRMR1dJnBhmomK4OFp0VCWWp2KkzaLee3w1gYmCmNgwFAOAQM7FBFVMfL9MVozVrWm0xeZmCaIYJ4SxA5lWxAGUvyCCiAuKAUAg52ICKSYRvwRQDE\/70pZXzsVbMe6xS9QcjY8gAgZGUAwAgpADpWYl\/n\/SFlAxTsZDDJqERFqUeAyU3Dd8EldMiwZM60AxAAjCKcZ5KIYQQmJFM5MVM1Ij5XM1j3Sv89iK9NRM+B4Zd2LOQzHOa4RrAYA5JEouJhFyex3i6V4AEiR0LgaKmUILAMwMpmmSdf1PhXc+KrwDxVgWFANAokAxw0AxACQIV8yiuuKpmFQn1szwbfsAxQCQIFwxxeU1T8WAaGT4GwUgV2CgNEz8E8vtWwNg+kAxw0AxACTIhFwMFJNJCwDMDBNyMVBMJi0AMDMwxWwV3rlXeOdeqIk1Y35Vaex16Dex5iSSmKTKRxDiOwT+X1WCYgAQhFRMs2J\/MalZiScZP8UEnFjT+9jUFMO+e8mX\/CQDxQAgME2TVPWtRXVFCRbF2MScVzOJiTXHHJteFON+mTgtADAvcMUUl9fCKSbuvJpJTKxpeU6mGXeqzcmCmDCvJhQDgANXjPLOveCK6ehqurmYgBNrek6mGXuqTX9BDGeKwrcAwFwRRTHCMylODx5wYk3PyTTjTbUZbKCE6cEBCETkXEy6\/8lJ0Ik1PSfTjDfVZhBB4D85ASAg4XIx0\/qv2oJNrDluMs14U22OOzH8V20ARCD0QEk8FxNzjvDJihmpGZ5Y07K8J9OMN9VmkOdi\/JuBYgAQRM7FxCW31yGe7gUgQaLnYqCY9FoAYGaI+lwMFJNmCwDMDPZA6e17yttQjGVBMQAkygTFYGLNTFoAYGaQcjFeigERyPDXCUDekHIxI4rJ8LQAALOBGChR5W0KxQAAkgWKAQCkiJyLgWIAAAnDZ70rLq9BMQCAxOGKwUAJAJAGUAwAIEW4YpCLAQCkAXIxAIAUwUAJAJAiUAwAIEWQiwEApAhyMQCAFMFACQCQIlAMACBFnFzMbSgGAJA0Ti4GigEAJA5TzBe3367cfrsCxQAAkgWKAQCkiGmaZP3hF4vqyu23oBgAQMJwxRSX16AYAEDicMXcfqsCxQAAEgeKAQCkCHIxAIAUQS4GAJAiGCgBAFIEigEApAhyMQCAFEEuBgCQIhgoAQBSxDRNUoViAADpwBWDXAwAIA24YpCLAQCkgRgofXj7rQ+hGABAslxdXUExAIC04IpZVFegGABA4nDFFJfXoBgAQOJgoAQASJHLSygGAJAal5eXdi7mTSgGAJAwXDHF5bVRxaCgoKDELAc\/\/Eiqn35x+80PhxRzDgAAsen3++T+p1\/cevPDW1AMACBpuGIW1RUoBgCQOFwxxeW1W8jFoKCgJF0OfvjRe6D09TfNQZoc981U25950IFxQO\/F5LhvhrijBMXcRNCBcUDvxSS0YkZzMVBMzkEHxgG9F5Mwirki9x9652LSPsVU25950IFxQO\/FJLhirq6uyP2Hn99684Nbb36QA8U0K6TS7OgqUfWOXdfRVWktIok0kgrNCqlE6Gt0oE2zslBphjTG2N5bqDQPdXVB1Q\/tHTq6puqdmEbq6JrmNJknmnSh0jRDn9lNVUxHVyvNwaCjq4Q418iMXyERJYMOdAgvmfG9Zw46urZAiJDMjCsmomRCK2ZRXcmBYuxLraOrqq6L627mrxDbDKFAB0qE7kDv3mOi6uga7z2TtT3jihl0NjUa1jGhFVNcXsteMeKPOfs0i8+0vEAYo5+nZoW4tw3tPNSmq6ZSUQkhRNWbOl\/oiKvU4\/W8Njkvz2rGNes6MeeSjRDHoAMJUfVDcfbh4hjP3uNNMKewd2dKimHRDSGEVHaHj27SBWcbb0SuYIo5lETj1Nhv8+Guri4sEKI+PDQ7uqbpeoU3ytscOAcObXJentV0Nr2bNQeDzqbG9+UVg0hxTHDFmKaZl4GS8+m1l\/glw1c7uupcQSOfWVHRrBD2AXHv7HOFsI+uvMDrx0QBPpsmNisf4L2IDpxGB47rPUcxpu0cvtrRNUdBbp\/xCnMwGAyadEHVDw9FDd\/moxiW9+lIC7x+wbGVHAF1xm8aDAadTblZs7PpLGg6VxczC68ZWgzRgbOgmMGgWREf69EPt8eRXjXy4ePq5UNCvZxHgECIf7NEZuQdowPDduBhlA4MopjBoFnR3G\/cMzvjcZ17Rivjohj90JQOGScjz5eTjxJxjPrQPtx05OGoZ0HuPRHZpK6YPORivK4QO17O+xXC\/vIHa9ZrSJSaYtCB4XrPrZhBR9dcvZdTxTTpgl0lVDJWMa5RF29yCorJYy7GqRWD+9hxvpz0EDsmc4UEa1Y+VWkxlVzMPHSgPWJJPhdjitoForIhRuyBkslew71jMoqRmvVRDHsXu\/boyF6cl1zM0A0R+akOMhRLe\/zBGp+tdH9SnUBbVROM813xu98VIp+q3Eryd5TmogMPI3bgxDtKIkgRSZKByOCq+si9ofHpXtVlEGdAo6pqYopxjZP8Bkqu1LBI96Z7RylXiol0qc0AiT8XM28k+1zMvJHyczE5ysUMBoPIj7reZFJ4ujfuKd0skn66d74kk\/rTvXnKxYAwoAPjgN6LSUjFfPr5rTc+uPUGFHOTQAfGAb0Xk2QUc9w3UVBQUDxLOMUsqiujikl7Uk9CCH7G\/AlAJgT0i62Y\/\/y8uLzmqZj0Aq3z8\/Pjs1cokUuoXzMYAr0XhyiKufXG+7feeH\/KiiGEZH6h3txCCEnhwzMvQDFxuDGKyfwqvdEFF0kc0HtxiKKYRXUFUczNKohi4gDFxCFyLia4YhJ4vmtsFGNsFAghqw275qBaJKS40Zb22V4lhQcHfHWnzJ+btg\/ZXiVDNTNZxv6auzWNEEJbrnWt1pV2aVGpokV5d9mHiAqpkVnDp\/fuLBBCv72W17XaT9fOLi264FS07vHH8em319euClEze6Q6UBJfJUlAMd5RjLFRKC4VhFOYcWTFGBsFIhTTKBFS2pG8Y2zYxx5Ui0tVI3sXpFTGRjHdmqZpmlAIM46sGJdzWtQ2CfdOt2Yf6yzNHn6KYb13ba8uEJdiXM5p3VtYYCZp3VvQaj9dd2t37rBtztLsEUUxr73x\/mv5iWKKG9VV2w475cJq2THO2UG1uFRaXeKK2SkPBTjHO2U5nGH2mcniF8VotRp1HKJRKrmiW9OkClc8w\/eXw5lZjWN8FcN6jzmE3mGdde1sdipc8YxlWZbVurdAWyKcsRdnjYi5mOkrZnwUs9HeKTOJbK8uVXc2HMXslMlqo\/2AK6b9YGloNCQ2DS3PXvGNYmrdFndMi2q1lhSOtCihLRGfdGvakEXk0GWGwxh\/xbDeu7asFr3De4+pokUXaOsnu6JbuzNkETl0meEwJmIuJldRTJuPdxolZ\/nV8VmjRMrbkjvaD5YKq+WClHmZH8X4RzFdrocWdZYtEZfIitEo1aTMCxRzR\/TYdYveEcsWF8w134Up5o7Te99eX0MxHmQ5UPKLYs4OqsXyNhv12IpxmUVEMU7mhZR25kgxE6IYq1vTaIspxVaFyywiinEyL\/K+ljXPirnu1u7QFlOKbRTZLE4Uo4nMC98Xihkip7kYLpTiUmlHlg6RKTw4OLbHU45QkIuRhaJpUtDCEr8OIspxHYdcjBCKpklBC0v8yr33E4tyXEJhVkIuRiKvuRi2QMrbco1dpPCED51EFIM7StZoomUkGpEqhEbsvXFHyZVokWpGdpE0YqdlcEdphLzmYnxrXCMgPBczxKgZ\/BSD52LcjAjFVzF4LmYy0QZKCYCne2MWPN0bBzzdG4cbo5jMr9IbXXCRxAG9F4cp5GKSUQyimDgFUUwcoJg4TCEXk4xiMr9Kb3TBRRIH9F4cIijms9deL7\/2enlUMenNyocoJmZBFBMHKCYOSSombUgO5qa8uT8ByIRQPmJz9362qK6MKiZUQwAAMApXTHF5DYoBACQOV4znQCnD0wIAzAZQDAAgRZCLAQCkCHIxAIAUwUAJAJAiUAwAIEWQiwEApAhyMQCAFMFACQCQIlAMACBFkIsBAKQIcjEAgBQRA6U\/vPb6H6AYAECyQDEAgBQxTZP88dPPFtWV\/4BiAABJY5om2fnrf32y+WX14ed\/+\/s\/zl6cv3jZP++\/+p\/v\/vef\/\/zXv\/79279\/++2333\/\/\/eLi4vLy8vLyimMCAMBELi8v\/x837Z1CcjW4tgAAAABJRU5ErkJggg==” alt=””]<\/p>\n
This string function was able to retrieve all forms of \u201cmuller\u201d without any collation change. I saw that all version of \u201cMuller\u201d is converted to the same SOUNDEX code. The only problem is the utilization of indexes by this function which is not ensure.<\/p>\n
Finally, I took a look at the FullText catalog feature which can be accent insensitive and that will include a FullText index with German language:<\/p>\n
CREATE FULLTEXT CATALOG FTSCatalog WITH ACCENT_SENSITIVITY=OFF AS DEFAULT\nCREATE FULLTEXT INDEX ON Person(name LANGUAGE German) KEY INDEX PK_Person\nGO<\/pre>\n\u00a0<\/span><\/p>\n
After I used the following queries based on the contains clause and the Formsof predicate with the inflectional option for my different forms of Muller:<\/p>\n
Select name from Person where contains(name,'FORMSOF(INFLECTIONAL,\"muller\")')\nSelect name from Person where contains(name,'FORMSOF(INFLECTIONAL,\"m\u00fcller\")')\nSelect name from Person where contains(name,'FORMSOF(INFLECTIONAL,\"mueller\")')<\/pre>\n[img64 src=”data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJwAAAD+CAIAAABA5vtLAAAPDklEQVR4nO2dTW\/byBnH5\/PkZlA2IH2DfIMcVjZ88PhD7KWRd1FvCzhquzVAwAHc1pVjrHqxCwVY5GCgTSxZTL3oHmxA8CnoriK\/RHJ2E8kywB5GHL6NKEricF74\/PGAIUckbfKX\/wxFP+SDjr7\/9+s39ddv6m9O6m9OGm9OGm\/qjZP66SgaTUbUnWg0TxrNuhMNEqejOHUjQs05ZE3UraOb29ubm5kjQd3y0Qeq29tb9M23+9Vq1dZR1Wq1mz19+PBBc6jZUYagCnRMmpoOKjYtZhg4GGnSiqlqtfrBr+Pj4+Pj40O\/dnf3PiguL9TbOFBNyx6FaeMxoQpU0wz+np1OB5umEBIJygf19hb9bkqnhj1qYMswxkBtPcsjn3BtJj6tZ\/n8s9aUG1Wr1cA1IoXa6\/Wsa9u6tiunXYxNTpekqSkE9c9RUL3\/tZvNJp0\/Pj4mM\/1+3zQtw8CxYMzExt1wys3HQT0\/P7csq9lsVk67pmlpCfVFTKgUpG3bh4eHtm33+\/1er2eaVj6fj4LhLtfwbF6dFWrgS6JpWqZlHR4emqa1u7tHAmMz7pfM5lc5hNDKgW8591UzsW+xM2o6qLu7e+fn581m89gvcl7IVcYUUOmi2y2PPqYN+Wct31YuTozz7ha+9cdDvfYrPKZWTrsjy1qWaVmXl5fXEWps5HK5XG6jQRcRQnRRnKaGSue9TjVNq9frkZFpd3cvCipjSPVAG806Dm49yyNcY0P1OtW\/\/jRQ37171+l0Op2OZdmV027ltOs9KMPAUVwbG7ncxsayg\/HFcm55OaccVGb32+\/3Dw8P6bXGBKiulRwCQdIEl9+2E6D61x8P9cov07QuLy99\/Y1lkeO0TWyaVrPZJFyvmGps5HIbjRfLuY3G1dXVi+XcxouNHFkgrkXEuVfehsDnzrbu8S+\/uPJtEN5mzD6ppoO6vb1tWRY5BXQ0IlM6LJmmGbf7JQYbb68aRiiWU\/3rj4fa8Svc\/Y6g2rZt25eXlwbGhoENA3eYqpcMo1Qn085+0Z0f\/eOu09kvouI+WUTF\/eBiaJ\/eD+Lu01UQ6u8nQXWP37TIlVGv19vd3bOubdKDbW9vx736DVOl\/S2ig23+WctzPVXDKAw1uP50UEkf0+l0rGsHqoltjG3bxqZhmpaBI6F26iWjuE\/OMMXs63vcJg8W7yJt8KxOP4u7zwio23Ghki6XjqN0TJoGKsVZwxEXSr4LqbwHJ9nK14VHXyi994tCJUSta9\/40uv1Li8vTcsyDPyeKXK6yb+GUaw4LfWSgYoV1haVIkKej5zFShEZpbpnn86efS3x9vn+\/Xsv1Js4UOm1rrfLJRe9247GQhWqarXa9osgpEQty4GKsY2Nd+\/eYdMgUNtMnTw1jKcnZAYVK24LXXY+OnlqILqq8bTiXzypFJ3V25UiCu8hzj5P3N9raqfm83nDwIGpd4YoNVTxNQGqZWPLoJf3nU7n\/Pz8+PiYXANPgMpoqRSdfpIsnzw1vMvjFtlN8fY5I1SlVa1Wf\/aLXN+SWxAkRlCxYWOj2Wwa2CBQfxaovS\/QF3tTbZEtqD\/5RS6CVlZWDIxJEKijmw\/O+GIY+Ke0tfeFx7m\/eT3dxpmGGhZBGI7ZyIhStqD+LxvKFtQM6u3btzpDzaY+f\/4cvKP03T+OIJSOt\/\/5LwPqA0+1e0Ou+1dL7d4wcaf2+32AKlIAVUPxgDoYDIJ\/egOoaQqgaiiAqqF4QL2\/vweoIqUp1IutfH5ra210J3vt6OHh4eFozb23vXZE1llbI0lJW0dbo5mL0ebOH9NJg1rSF6rDkgC+CHya37q42MoTZt6Z\/NaFd4PwtiqIB9ThcCgBVAqDzrv+Q4hApe3eGe9qapo1O1CP1pDff1FQ1\/j+upyVKagOKsJ3HNQHD1U1AWcHqq\/3jYT64LmoUq\/vfdAWarYFUDUUQNVQAFVDpQe13RtCpBYpQe1yFkIIpmSaONEoqPw6nG632765g2jf3HW73Qg2ikFFCAk\/oTIEOFXDAKdqGJI41XNXdg6o7IO0NnMIoZWq03JWWkRocbPOXHNxs06mosHME8KdSm\/HJgCV7VRrM7e45HIijLWGytWp+7I4dXGztLJUsu7aN3ftg9Xcyiobmy5QuTo1bajjnbpZP1jNfX3WvrmrrCyVDkLwvDhpO\/E0QggtlSyyzmpxESG0WhGNLTqy4lQHVbUYhseGelZadMxN25HTIndkxqk3Z6XF1crBKlqpMrrZMFTXpo5ZD5TpljPj1Ju7+tdLucWl4gFr7GRD9Xez6oy12XEqGSNXK25LtUixHawiRveLigfOHtBqRR2oGXJquKX+9dKocyXfeYIOrhaDF0pqQJXEqQkI7ijRkMSpyUAVfjYlCXCqhgFO1TDSdiq\/7A1wKo20ncpbwvNIJJmmCpVr98vjSFQUQNVQAFVDAVQNJR6q+8j+fDcKxx5Jq1xA3soVrXIBoUK5NZovlFtkGlxSV4KhJvgcaBTUQsHlRBgzsQHUSM3S\/c75coVIqOUydkDVcAFjNjaAGqkZoHJ1arlVG1Gt4UK5FoLnxUnbiaeR4+tWuVDA2N+VyymuUCvxodLXo\/CCOkJVw2F4NhOq52Pazu61pZMUUOcnOhmq3SoXcG1UZyoGVNemjllrynTL4qEmQjQG1NEFE66xxk42VH83q85YKxrq0dr8adwxodqUE+2KvXXfGN0vLRtXLiBcA6gxoXrfK4fmexHKZKihFs+VUIFxoeSWjfN8i+VxtpKWaKcmJ7ijRAVQNRSnU0FeOAlQxQigaqi0oXJNZ+FxJCoqbaigFMSDqG3bgwELKqcfBkpHpDACQNVKbKgQSsfZDz8GoYoeaEDzqtfrAVTdBFA1FAOq8CEBYs5gjKnfwft+UxGPl8JGXf3yPhiu+1dFAFVD8YTKuqPE+2C47l8V8YPKvvfL+2C47l8V8YYazPvlfTBc96+KOEP9FqAKkNZQs1o\/lR\/U4XAoAdRM1k\/VHWom66dmDWom6qdmEKr+9VOzBjUT9VO1hppV8YYKd5QECKBqKL5QvwGoIpQ21HTqhkKkCpV3Eo0Mb3oUPuVElEL9O7zvN+Xo8nygSAxUlPn3\/YJTNQxwqoYhlVOhfmoyIYlToX5qkpElp2amfqokTk0S6ninZqV+aracmpH6qRlzajbqp2bMqdmon5o1p2aifmrmnBpu0a9+qlROTUBwR6ktmVOTgSr8nAoPcKqGAU7VMMQ4lV8OBzi1LcqpvCU8m0T4VABUrt0vv+NRRQBVQwFUDQVQNZQsUKF+aoKSAirUT01WUkANAIb6qXNKNqhQPzUBpQB1D+qnpiyJoEL91KTEH+qfYkGF+qkJSg6oUD81UUkBFeqnJispoCYouKNkA1QtBVA1FEDVUGKgck1n4Xc8qkgMVBBvCYAK3S9XAVQNBVA1FEDVULJAPfIXpEgealQ6yySp9mdzOaC6r7Wf92nGKKgx01nY2wLUkWbofuctFRIJNV46y5htASrR9FDnrj8QDTVWOovNTGFRKcFFIqjkBVkcx9SY6SzMFBalElwkgkrJckw8i5nOwkxhUSfBRTaofFNE46azMFNY1ElwkQJqWsnc8dJZxqWwqJPgIgXUh+SK+kyGGmoJprPYNjuFRZ0EF1mgJiW4o2SnAHUToKYurifh\/v4eoAoQQNVQYqBCOgtXiYEK4ip+RG3bHgxYULn+SBBvDQYDgKqbCNS\/BaBCKB1nP\/wYhCp6uAHNq16vB1B1E0DVUAyowocEiDmDMaZ+B+WrUxG\/Ssfsq1\/eB8N1\/6oIoGoonlDvAaoY8YNK7v0CVAECqBqKM9Q\/AlQB0hrqxVY+v7Xlf\/rK+9qmtSOyztpanqS9HW3lPflvtAJzIq9jS1H8oA6HQwmgIk\/6aQANaaGv0PPO5LcuvBvM+4xP2tIdKoVB513\/IUSg0nbvjHc11cyaNajuc5MuvLFQk3ljYvrKIFQHFeE7DmqSTw6kraxB9fW+kVAfkntyIG1pDTWrAqgaCqBqKICqodKGyi89H8IbqULlnUSDJChfKnzKiWgUVH7dTrfbfdmyMx5d7s+npg4VIST8tIoNcKqGAU7VMKRy6rwvJnyIcOqr8iOE0JOa09JaX0BoofycueZC+TmZisYzW0jiVHo7NgGobKe+Kj9aKLicCGNNoWbJqQvl9SeF9Vf2y5b9cgc\/eoLZ2NSHKolTk4Q63qnl5zv40Zetly279KSwvhOC58VJ24mnEUKosP6KrIMfLyCEcEk0vHGRglP\/Ko9THVS1x2F4bKit9QXH3LQdOS2yRgpOTRtqlFNbrfUFXNrB6EmN0c2Gobo2dcy6o0C3nDGntuznXxYeLRQe77DGTjZUfzerwlibNaeSMRKX3JbaY4ptByNG94se7zh7QLikAtTMOZXp3VHnSr7zBB1cexy8UJIdqlROTUBwR+mlZE5NBqrwcyo8wKkaBjhVwxDjVH45HODUl6KcylvCs0mETwVA5dr98jseVQRQNRRA1VAAVUPxh\/qHWFDdR\/bnu1E49nii6qf6686oVoMxLCmgplVBKl79VIAaqSmc6gXMr9ZbrPqpADVSw+EQ\/XY6qJxrvcWpn6patdSw5IJKX4\/CC2qc+qmqVUsNSyKo8xOdDDVm\/VSlqqWGxR9qORbURIjGgBqvfqpS1VLDkgPq0dr8adwxoU6un6patdSwpIDqfa8cmu9FKJOhhlqC9VNVq5YalhRQExTcUbIBqpYCqBoKoGooMVC5prPwOx5VJAYqiLc4Q53yhj50v\/MLoGqoFKD+BaCmLICqoWSBeuQvSJE81Kh0lklS7c\/mckB1X2s\/79OMUVBjprOwtwWoI83Q\/c5bKiQSarx0ljHbAlSi6aHOXX8gGmqsdBabmcKiUoKLRFDJC7I4jqkx01mYKSxKJbhIBJWS5Zh4FjOdhZnCok6Ci2xQ+aaIxk1nYaawqJPgIgXUtJK546WzjEthUSfBRQqoD8kV9ZkMNdQSTGexbXYKizoJLrJATUpwR8kGqFoKoGoogKqhxECFdBauEgMVxFX8iI6FyvVHgngLoGoogKqhAKqGAqgaCqBqqOFwiP75\/b9OThq9u493dx8\/fvyl0Tz75ddPv3769OnT58+f+\/1+v98fjHTv0TA93d8P76dWir+fZBoMBv8H3a30QHitKsMAAAAASUVORK5CYII=” alt=””]<\/p>\n
As expected the result was consistent with the other ones as we don\u2019t have all forms when searching for \u201cmuller\u201d. In contrary searching for \u201cm\u00fcller\u201d or \u201cMueller\u201d gives me all the results.<\/p>\n
In conclusion, the FullText capabilities of SQL Server is certainly the best solution as it will be also faster with a huge number of rows and give the possibility to not change the collation which could be sometimes a real nightmare but we have to use \u201cM\u00fcller\u201d instead of \u201cmuller\u201d to retrieve all the expected results.<\/p>\n","protected":false},"excerpt":{"rendered":"
Some days ago, one of my customer claimed that searching for \u201cMuller\u201d doesn\u2019t return \u201cMueller\u201d and \u201cM\u00fcller\u201d as well! This is typically an issue due to the collation of the SQL Server database, but how to resolve this problem? The collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation. If […]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[597,598,599,51],"type_dbi":[],"class_list":["post-5087","post","type-post","status-publish","format-standard","hentry","category-technology-survey","tag-accent-insensitive","tag-accent-sensitive","tag-collation","tag-sql-server"],"acf":[],"yoast_head":"\n
How to solve accent sensitive problems? - dbi Blog<\/title>\n<meta name=\"description\" content=\"Some days ago, one of my customer claimed that searching for \u201cMuller\u201d doesn\u2019t return \u201cMueller\u201d and \u201cM\u00fcller\u201d as well! This is typically an issue due to the collation of the SQL Server database, but how to resolve this problem? The collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to solve accent sensitive problems?\" \/>\n<meta property=\"og:description\" content=\"Some days ago, one of my customer claimed that searching for \u201cMuller\u201d doesn\u2019t return \u201cMueller\u201d and \u201cM\u00fcller\u201d as well! This is typically an issue due to the collation of the SQL Server database, but how to resolve this problem? The collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-16T04:45:34+00:00\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Savorgnano\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Savorgnano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"26 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-solve-accent-sensitive-problems\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-solve-accent-sensitive-problems\\\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"How to solve accent sensitive problems?\",\"datePublished\":\"2015-07-16T04:45:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-solve-accent-sensitive-problems\\\/\"},\"wordCount\":5067,\"commentCount\":0,\"keywords\":[\"Accent Insensitive\",\"Accent Sensitive\",\"Collation\",\"SQL Server\"],\"articleSection\":[\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-solve-accent-sensitive-problems\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-solve-accent-sensitive-problems\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-solve-accent-sensitive-problems\\\/\",\"name\":\"How to solve accent sensitive problems? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2015-07-16T04:45:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"description\":\"Some days ago, one of my customer claimed that searching for \u201cMuller\u201d doesn\u2019t return \u201cMueller\u201d and \u201cM\u00fcller\u201d as well! This is typically an issue due to the collation of the SQL Server database, but how to resolve this problem? The collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-solve-accent-sensitive-problems\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-solve-accent-sensitive-problems\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-solve-accent-sensitive-problems\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to solve accent sensitive problems?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/b6bce7d75118b35bdb3b439ad6a9ca3c\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \\\/ Financial Services, Chemicals & Pharmaceuticals, etc.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-savorgnano\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to solve accent sensitive problems? - dbi Blog","description":"Some days ago, one of my customer claimed that searching for \u201cMuller\u201d doesn\u2019t return \u201cMueller\u201d and \u201cM\u00fcller\u201d as well! This is typically an issue due to the collation of the SQL Server database, but how to resolve this problem? The collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/","og_locale":"en_US","og_type":"article","og_title":"How to solve accent sensitive problems?","og_description":"Some days ago, one of my customer claimed that searching for \u201cMuller\u201d doesn\u2019t return \u201cMueller\u201d and \u201cM\u00fcller\u201d as well! This is typically an issue due to the collation of the SQL Server database, but how to resolve this problem? The collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation.","og_url":"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/","og_site_name":"dbi Blog","article_published_time":"2015-07-16T04:45:34+00:00","author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"26 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"How to solve accent sensitive problems?","datePublished":"2015-07-16T04:45:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/"},"wordCount":5067,"commentCount":0,"keywords":["Accent Insensitive","Accent Sensitive","Collation","SQL Server"],"articleSection":["Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/","url":"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/","name":"How to solve accent sensitive problems? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-07-16T04:45:34+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"description":"Some days ago, one of my customer claimed that searching for \u201cMuller\u201d doesn\u2019t return \u201cMueller\u201d and \u201cM\u00fcller\u201d as well! This is typically an issue due to the collation of the SQL Server database, but how to resolve this problem? The collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to solve accent sensitive problems?"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals & Pharmaceuticals, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5087"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5087\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5087"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}