Skip to content

Instantly share code, notes, and snippets.

@petergi
Created December 27, 2023 20:09
Show Gist options
  • Save petergi/27fbd70463a90137eacdfdc8b7efac68 to your computer and use it in GitHub Desktop.
Save petergi/27fbd70463a90137eacdfdc8b7efac68 to your computer and use it in GitHub Desktop.
Only ever tested in MS SQLServer.
CREATE FUNCTION replaceAccentChar (@source as varchar(255))
RETURNS varchar(255) AS
BEGIN
declare @charList as varchar(20)
declare @temp as varchar(255)
declare @t asint
set @temp = @source
set @charList = 'aeioucn'
set @t = 0
while@t <= len(@charList)
begin
set @temp = replace(@temp, substring(@charList, @t, 1),
substring(@charList, @t, 1))
set @t = @t + 1
end
set @temp = Replace(@temp, 'œ', 'oe')
set @temp = Replace(@temp, '’', '''')
return@temp
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment