{"id":5087,"date":"2015-07-16T06:45:34","date_gmt":"2015-07-16T04:45:34","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/"},"modified":"2015-07-16T06:45:34","modified_gmt":"2015-07-16T04:45:34","slug":"how-to-solve-accent-sensitive-problems","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/how-to-solve-accent-sensitive-problems\/","title":{"rendered":"How to solve accent sensitive problems?"},"content":{"rendered":"<p>Some days ago, one of my customer claimed that searching for \u201cMuller\u201d doesn\u2019t return \u201cMueller\u201d and \u201cM\u00fcller\u201d as well!<br \/>\nThis is typically an issue due to the collation of the SQL Server database, but how to resolve this problem?<br \/>\nThe collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation.<\/p>\n<p>If a run the following query:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">Select name from Person where name like 'muller'<\/pre>\n<p>[img64 src=&#8221;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&#8221; alt=&#8221;&#8221;]<br \/>\nI get only \u201cMuller\u201d which is normal as I use an accent sensitive collation so <strong>u<\/strong> is not the same as <strong>\u00fc<\/strong>\u2026<br \/>\nNext, if I execute the same query by using an accent insensitive collation:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">Select name from Person where name like 'muller' collate Latin1_GENERAL_CI_AI<\/pre>\n<p>I have as result:<\/p>\n<p>[img64 src=&#8221;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=&#8221; alt=&#8221;&#8221;]<\/p>\n<p>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<br \/>\nBut I get not yet \u201cMueller\u201d which is a synonym of \u201cM\u00fcller\u201d without using a \u00fc in German writing.<br \/>\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>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">Select name from Person where name like 'muller' collate German_PhoneBook_CI_AI<\/pre>\n<p>[img64 src=&#8221;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=&#8221; alt=&#8221;&#8221;]<\/p>\n<p style=\"margin-bottom: 0.0001pt;line-height: normal\">As expected, I received just \u201cMuller\u201d which is quite normal as \u201cMuller\u201d in German speaking is not \u201cM\u00fcller\u201d\u2026<br \/>\nLet\u2019s try with:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">Select name from Person where name like 'm\u00fcller' collate German_PhoneBook_CI_AI<\/pre>\n<p>[img64 src=&#8221;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==&#8221; alt=&#8221;&#8221;]<\/p>\n<p style=\"margin-bottom: 0.0001pt;line-height: normal\">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<p style=\"margin-bottom: 0.0001pt;line-height: normal\">Getting the result excepted by my customer seems like an impossible task by just changing the column collation.<\/p>\n<p style=\"margin-bottom: 0.0001pt;line-height: normal\">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<pre class=\"brush: sql; gutter: true; first-line: 1\">select * from Person where soundex(Name) like soundex('muller')\nselect soundex('muller'), soundex('m\u00fcller'), soundex('mueller')<\/pre>\n<p>[img64 src=&#8221;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==&#8221; alt=&#8221;&#8221;]<\/p>\n<p style=\"margin-bottom: 0.0001pt;line-height: normal\">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<p style=\"margin-bottom: 0.0001pt;line-height: normal\">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<pre class=\"brush: sql; gutter: true; first-line: 1\">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<p style=\"margin-bottom: 0.0001pt;line-height: normal\"><span style=\"font-size: 9.5pt;font-family: Consolas\">\u00a0<\/span><\/p>\n<p style=\"margin-bottom: 0.0001pt;line-height: normal\">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<pre class=\"brush: sql; gutter: true; first-line: 1\">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<p>[img64 src=&#8221;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=&#8221; alt=&#8221;&#8221;]<\/p>\n<p style=\"margin-bottom: 0.0001pt;line-height: normal\">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<p style=\"margin-bottom: 0.0001pt;line-height: normal\">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":"<p>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&hellip;&nbsp;<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[99],"tags":[599],"class_list":["post-5087","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-collation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to solve accent sensitive problems? - dbi services | 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 services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\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:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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\\\/adf6293d8bc8a7a26490acfe2918b6d7\"},\"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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"keywords\":[\"Collation\"],\"articleSection\":[\"SQL Server\"],\"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 services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2015-07-16T04:45:34+00:00\",\"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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/adf6293d8bc8a7a26490acfe2918b6d7\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than 20 years of experience in Microsoft software development and SQL Server database solutions, specializing in SQL Server installation, performance analysis, and best practices. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server 2012 through 2017, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. Prior to dbi services, he was a software engineer at Ciba Specialty Chemicals in Basel. He holds a Master's degree in Informatics from the University of Mulhouse. His industry experience covers banking and financial services, chemicals, and pharmaceuticals.\",\"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 services | 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 services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2015-07-16T04:45:34+00:00","author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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\/adf6293d8bc8a7a26490acfe2918b6d7"},"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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"keywords":["Collation"],"articleSection":["SQL Server"],"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 services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-07-16T04:45:34+00:00","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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","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":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/adf6293d8bc8a7a26490acfe2918b6d7","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than 20 years of experience in Microsoft software development and SQL Server database solutions, specializing in SQL Server installation, performance analysis, and best practices. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server 2012 through 2017, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. Prior to dbi services, he was a software engineer at Ciba Specialty Chemicals in Basel. He holds a Master's degree in Informatics from the University of Mulhouse. His industry experience covers banking and financial services, chemicals, and pharmaceuticals.","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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}