eventually i forced to write a function.
i put here for friends like use :
CREATE FUNCTION [dbo].[CONVERTOR](
@string nvarchar(10)
)
returns nvarchar(10)
AS BEGIN
declare @converted nvarchar(10),
@charnvarchar(10),
@counterint,
@lengthint,
@unicodeint,
@asciiint
set @counter = 1
set @converted=N'';
set @length=LEN(@string)
while(@counter <= @length)
begin
set @char=substring(@string,@counter,1)
set @unicode= UNICODE(@char)
set @char=@unicode-1776
set @converted=@converted+@char;
set @counter = @counter + 1
end
return @converted
END
select dbo.CONVERTOR(myFiled) FROM myTable
this scalar function convert unicode to ascii 🙂
thanks all anyway