i use Stored procedure to send sms arabic it send as ???????

mostafa saeed

i use Stored procedure to send sms

when sms message english it send prefectly

but when i change message to arabic it send as question mark ???????/

create procedure [dbo].[pr_SendSmsSQL] @MobileNo varchar(12), @smstext as varchar(300), @sResponse varchar(1000) OUT as BEGIN Declare @iReq int,@hr int Declare @sUrl as varchar(500) DECLARE @errorSource VARCHAR(8000) DECLARE @errorDescription VARCHAR(8000) -- Create Object for XMLHTTP EXEC @hr = sp_OACreate 'Microsoft.XMLHTTP', @iReq OUT print @hr if @hr <> 0 Raiserror('sp_OACreate Microsoft.XMLHTTP FAILED!', 16, 1) set @sUrl='http://api.clickatell.com/http/sendmsg?user=devendar&password=csx19csx&api_id=3360313&to=#MobNo#&text=#Msg#' set @sUrl=REPLACE(@sUrl,'#MobNo#',@MobileNo) set @sUrl=REPLACE(@sUrl,'#Msg#',@smstext) print @sUrl -- sms code start EXEC @hr = sp_OAMethod @iReq, 'Open', NULL, 'GET', @sUrl, true print @hr if @hr <> 0 Raiserror('sp_OAMethod Open FAILED!', 16, 1) EXEC @hr = sp_OAMethod @iReq, 'send' select @iReq print @hr if @hr <> 0 Begin EXEC sp_OAGetErrorInfo @iReq, @errorSource OUTPUT, @errorDescription OUTPUT SELECT [Error Source] = @errorSource, [Description] = @errorDescription Raiserror('sp_OAMethod Send FAILED!', 16, 1) end else Begin EXEC @hr = sp_OAGetProperty @iReq,'responseText', @sResponse OUT print @hr insert into send_log (Id, mobile, sendtext, response, created, createddate) values(0, @MobileNo, @smstext, @sResponse, 'System', GETDATE()) end end

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

mostafa saeed7y ago
no
the systems which i use accept arabic when send message arabic out sql it send correctly
but when send message from sql it send as ???????????/
Rafnas T P7y ago
Hi,

it is may because of the system from which you send message has arabic font installed, but for reciever system does not have arabic font, try installing arabic font to both system.

Thank you.
mostafa saeed7y ago
of course

i use the correct user and password and datatpe nvarchar

this is StoreProcedure which i was

the sms it send correctly if it write in english but when i write it with arabic it send as ?????????
ALTER procedure [dbo].[pr_SendSmsSQL2]
@MobileNo varchar(11)='01098245147',
@smstext Nvarchar(300) =N'????? ?????? ????? ??? ???????.??? ??? ?????? ??? ?????? .',
@sResponse varchar(1000) ='mmmm' OUT
as
BEGIN
Declare @iReq int,@hr int
Declare @sUrl as nvarchar(500)
DECLARE @errorSource nVARCHAR(max)
DECLARE @errorDescription nVARCHAR(max)
-- Create Object for XMLHTTP
EXEC @hr = sp_OACreate 'MSXML2.XMLHTTP', @iReq OUT
print @hr
if @hr <> 0
Raiserror('sp_OACreate MSXML2.XMLHTTP FAILED!', 16, 1)
set @sUrl=N'https://smsvas.vlserv.com/kannelsending/service.asmx/SendSMS?UserName=mmmm&Password=uxxs8EzRjp&SMSText=#Msg#&SMSLang=A&SMSSender=2B Egypt&SMSReceiver=#MobNo#'
set @sUrl=REPLACE(@sUrl,'#MobNo#',@MobileNo)
set @sUrl=REPLACE(@sUrl,'#Msg#',@smstext)
print @sUrl
print @smstext
-- sms code start
EXEC @hr = sp_OAMethod @iReq, 'Open', NULL, 'GET', @sUrl, true
print @hr
if @hr <> 0
Raiserror('sp_OAMethod Open FAILED!', 16, 1)
EXEC @hr = sp_OAMethod @iReq, N'send'
select @iReq
print @hr
if @hr <> 0
Begin
EXEC sp_OAGetErrorInfo @iReq, @errorSource OUTPUT, @errorDescription OUTPUT
SELECT [Error Source] = @errorSource, [Description] = @errorDescription
Raiserror('sp_OAMethod Send FAILED!', 16, 1)
end
else
Begin
EXEC @hr = sp_OAGetProperty @iReq,'responseText', @sResponse OUT
print @hr
end
end
Rajat Jaiswal7y ago
Hi,

The first and for most important you are exposing your username and password. Please, change it asap.
Secondly, please, make sure you user NVARCHAR data type in SQL Server to store the message.
Thanks
Rajat