Avatar of Nico2011
Nico2011
Flag for United Kingdom of Great Britain and Northern Ireland asked on

collate Latin1_General_CI_AI - select distinct from MSSQL Table

Hello,

Is there a way to select 'distinct' region names with foreign characters please?  I am looking to create a list of regions and am trying to avoid getting duplicates if they are wrongly typed in, or if they have foreign characters, for example, one user might have added a property in the 'Cote d'Azur' and another may have added a property in 'Cóte d'Azur' - with an accent on the 'o', but Idon't want to list *both* regions in my list as they are essentially the same region...

Thanks in advance for your help!
ASPMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Nico2011

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
sognoct

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Guy Hengel [angelIII / a3]

to cover "all" typos, you need to have a table that does cover the typos, and gives the correct alternative, and you return that value.
this however also means that you need to "catch" and handle all the values that are NOT yet in that table on a daily basis.
there is not "magic" solution for this; though you migth check out SOUNDEX() function to see if it would help
Nico2011

ASKER
Thanks!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy