Replace character \xFFFD
Application Type
Traditional Web, Mobile

How to replace the chacater "\xFFFD" ( ? ), on Text Label ? 

Semttulo.png

Consegui resolver ... 

Achei uma Function no MSSQL .



/****** Object:  UserDefinedFunction [dbo].[RemoverChar]    Script Date: 21/03/2021 00:48:52 ******/

SET ANSI_NULLS ON

GO


SET QUOTED_IDENTIFIER OFF

GO




--sc_13032009_RemoverChar

CREATE  function [dbo].[RemoverChar](@x varchar(1000))

Returns varchar(1000)

as 

Begin

declare @i int,@ret varchar(1000)

select @i=1,@ret='' 

while @i<=len(@x) begin

  IF ASCII(SUBSTRING(@X, @I, 1)) <> 0 BEGIN

select @ret=@ret+substring(@x,@i,1) 

  end  

  select @i=@i+1

end


return @ret 

End





GO

mvp_badge
MVP

Hi Franco, 

I hope you're well.

Have you tried using replace function?

Example:

or

Regards.

Consegui resolver ... 

Achei uma Function no MSSQL .



/****** Object:  UserDefinedFunction [dbo].[RemoverChar]    Script Date: 21/03/2021 00:48:52 ******/

SET ANSI_NULLS ON

GO


SET QUOTED_IDENTIFIER OFF

GO




--sc_13032009_RemoverChar

CREATE  function [dbo].[RemoverChar](@x varchar(1000))

Returns varchar(1000)

as 

Begin

declare @i int,@ret varchar(1000)

select @i=1,@ret='' 

while @i<=len(@x) begin

  IF ASCII(SUBSTRING(@X, @I, 1)) <> 0 BEGIN

select @ret=@ret+substring(@x,@i,1) 

  end  

  select @i=@i+1

end


return @ret 

End





GO

Sim,

mesmo assim vem com esse caractere .



Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.