collation in stored procedure

Question

I have a table which contains data in different languages. All fields are nvarchar(max). I created a stored procedure which trim values of all the fields

Create Proc [dbo].[TrimValues]
as
update testdata 
set city = dbo.trim(city),
state = dbo.trim(state),
country = dbo.trim(country),
schoolname = dbo.trim(schoolname)

after trim all non-english text become ?????

Answer 1

Something wrong with your dbo.trim user-defined function then I'm guessing. Do you have the source for it?

Answer 2

make sure that you trim functions accepts nvarchar and not just varchar otherwise it will do an implicit conversion, can you post the code

Answer 3

Either the parameter to your Trim user-defined function is declared as varchar instead of nvarchar or you are using a variable declared as varchar in that function to build the results or you have declared the results to be varchar instead of nvarchar. We'd need to see the source of the Trim function to know for sure.