does anyone know where i can find a user defined function that replaces accented characters with their normal ones

i want to replace all accented characters since for some reason sql server does not store the characters properly, or when they exported to excel for html they are displayed incorrectly

thanks

Come again?

Got an example?

REPLACE?

FROM SQL BOL:
REPLACE (string1, string2, string3)

SELECT REPLACE('abcdefghicde','cde','xxx')
GO

(no column name)
abxxxfghixxx

Can you just force an Accent-Insensitive collation for the comparison? This is lots faster, easier, and more reliable than trying to "skin the string" yourself.

Brett: What they want is to convert any of (À, Á, Â, Ã, Ä, Å) into A. There are lots of letters, and some strange conversion rules. A collation change is easy, standard, and reliable.

-PatP

Why Do people use other than out of the box collation?

I mean, I know there are certain situations....but I haven't seen one where it's been needed.

I love when they set up case sensitive....

Thanks for coming up for some air.....

To replace accent with a CLR, SQL Server...
XooWiki