SQL Server cannot show apostrophe (') when database is restored -

SQL Server cannot show apostrophe (') when database is restored -

i restore database , select rows. apostrophe (') cannot show correctly. info type of column varchar.

the actual text

cm's approval - payment of legal

but shown this:

https://drive.google.com/file/d/0b5_hciy4bujmwfrftkr0bm5qofe/view?usp=sharing

any suggestion please.

sql-server