collation in stored procedure
Posted
by Sharique
on Stack Overflow
See other posts from Stack Overflow
or by Sharique
Published on 2010-06-10T13:27:54Z
Indexed on
2010/06/10
13:32 UTC
Read the original article
Hit count: 250
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 ?????
© Stack Overflow or respective owner
