select 'my chars'

declare @x xml
set @x = N'<tag>abc</tag>'
set @x.modify (N'replace value of (/tag/text())[1] with "我"')
select @x

update yourtable
set yourvalue = N'your chinese characters'
where id = yourid