dashboard is showing French character é as" ? "

[rmuhammad]

on the dashboard French character is showing é as ?  any suggestion why it happens and how we can handle this?

[balabhaskarqlik]

Try to use the UTF-8 unicode

Or

Create second Table with Nvarchar Type In sql server as this:

IF EXISTS(SELECT * FROM   NewTbl)

DROP TABLE NewTbl

SELECT

field1,field2,,

convert(nvarchar(50),Field3) Field3

INTO [MyDb].dbo.NewTbl

FROM [MyDb].dbo.PreviousTbl;