Log in to AnswerLog in to Follow
Franco Martins
13Views
3Comments
Solved
Replace character \xFFFD
Question
Mobile
Traditional Web
Application Type
Traditional Web, Mobile

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

Semttulo.png

0
0
on 8th Mar

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

See solution in context
0
0
on 21th Mar
Agno Silveira
mvp_badge
MVP

Hi Franco, 

I hope you're well.

Have you tried using replace function?

Example:

or

Regards.

0
0
on 8th Mar

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

0
0
on 21th Mar

Sim,

mesmo assim vem com esse caractere .



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