How to solve this for Bangla,Hindi,China,Japanee font
No Date Ttile
18-0002-01 2018-01-25 ????? ???? ?????? ??? ??????? ???? ?????? ??? ?????? ??????
18-0003-01 2018-01-25 ???? ?? ?????? ?? ?????? ?? ???? ???? ??? ??? ??????
1st Problem :
SELECT No, Date, Title
FROM vpro.News
WHERE (Title LIKE N'%??????? %')
Output :
No Date Ttile
NULL NULL NULL
2nd Problem:
how to difference
WHERE (Title LIKE N'%??????? %') OR // manual where condition
(Title LIKE '%??????? %') // From UI Come where condition