store procedure

Question

plz tell me in my store procedure put the code of send message to mob number but cant send marathi message plz tell me solution

Vishal Jadav · Answer

Hi Declare the message variable as NVARCHAR datatype which will then accept any language string. Try to pass it to you Send sms function. Hope it helps. Thanks

Chandu Kumawat · Answer

set @smstext=N'here marathi msg' but it sent me question marks like this ????????????????? ???????????????? ???????????????

Ankur Mistry · Answer

Before your field name put N N prefix before string in sp will allow you to display message in Marathi N-prefix tells sql server to treat the string as a unicode value

Chandu Kumawat · Answer

what is meaning of that sir using this code can i send sms in marathi language from store procedure

Ankur Mistry · Answer

Use N' N'%'+@SearchText +'%'