CREATE FUNCTION [dbo].[UTF8_TO_NVARCHAR](@in VarChar(MAX))
    RETURNS NVarChar(MAX)
AS
BEGIN
    DECLARE @out NVarChar(MAX), @i int, @c int, @c2 int, @c3 int, @nc int
   
    SELECT @i = 1, @out = ''
      
    WHILE (@i <= Len(@in))
    BEGIN
       SET @c = Ascii(SubString(@in, @i, 1))
   
       IF (@c < 128)
       BEGIN
          SET @nc = @c
          SET @i = @i + 1
       END
       ELSE IF (@c > 191 AND @c < 224)
       BEGIN
          SET @c2 = Ascii(SubString(@in, @i + 1, 1))
            
          SET @nc = (((@c & 31) * 64 /* << 6 */) | (@c2 & 63))
          SET @i = @i + 2
       END
       ELSE
       BEGIN
          SET @c2 = Ascii(SubString(@in, @i + 1, 1))
          SET @c3 = Ascii(SubString(@in, @i + 2, 1))
            
          SET @nc = (((@c & 15) * 4096 /* << 12 */) | ((@c2 & 63) * 64 /* << 6 */) | (@c3 & 63))
          SET @i = @i + 3
       END
   
       SET @out = @out + NChar(@nc)
    END
    RETURN @out
END

create trigger [dbo].[tIU_DICOMPatients] on [dbo].[DICOMPatients] for INSERT,UPDATE as
begin

if update(PatientNam)
  update t set  
  PatientNam = dbo.UTF8_TO_NVARCHAR(i.PatientNam)
  from inserted i, DICOMPatients t
  where i.PatientNam like char(0xd0)+'_'+char(0xd0)+'%'
   and t.PatientID = i.PatientID

end

go

create trigger [dbo].[tIU_DICOMStudies] on [dbo].[DICOMStudies] for INSERT,UPDATE as
begin

if update(PatientNam)
  update t set  
  PatientNam = dbo.UTF8_TO_NVARCHAR(i.PatientNam)
  from inserted i, DICOMStudies t
  where i.PatientNam like char(0xd0)+'_'+char(0xd0)+'%'
   and  t.StudyInsta = i.StudyInsta

end