store procedure

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

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

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

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

Use N'

N'%'+@SearchText +'%'