Ed Wagner - Saturday, May 6, 2017 3:13 PM
I might be mistaken, but I don't think the characters that the OP has provided would be lost on a varchar parameter. At least on my my instance the below SQL returns:string
------------------------------
Jørgen Ørum <jørgen@ærø.dk>
aß?CREATE TABLE #Test (string varchar(30));
GO
INSERT INTO #Test
VALUES
('Jørgen Ørum <jørgen@ærø.dk>'), --OPs example email
('αβγ'); -- Some more random Greek characters.
GO
SELECT *
FROM #test;
DROP TABLE #Test;
GO
So the only character that was "lost" was γ. I can't see why a varchar parameter would therefore be unhappy to receive the characters in the OPs post.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk