Peruttu

sql server send sms with arabic solve issues

i use sql server 2014 to send sms it work correctly if the message English

but if Message write with arabic it send as question mark ???????????///

this is code which i use

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 '[login to view URL]', @iReq OUT

print @hr

if @hr <> 0

Raiserror('sp_OACreate [login to view URL] FAILED!', 16, 1)

set @sUrl=N'[login to view URL] 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

Taidot: .NET, C# -ohjelmointi, Tietokannan hallinto, Microsoft SQL Server, SQL

Näytä lisää: send sms sql server, script send sms sql server 2005 smsc, send sms via sql server 2008, sql_latin1_general_cp1_ci_as arabic, sql server japanese collation, sql server chinese collation, sql server character set, how to insert arabic text in sql server, sql server utf-8 collation, how insert arabic/urdu characters in sql server, sql server collation list, send receive sms sql server database, send sms mobile sql server, sql server 2008 sms message, send column data sms sql server 2008, send sms sql server 2008, api send sms sql server, sql server scheduled web sms send service, sql server call sms web service, send sms sql server 2008 agent

Tietoa työnantajasta:
( 0 arvostelua ) Egypt

Projektin tunnus: #19610896

10 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

AliSafder

Dear Sir, My name is Ali and I can work on the project with immediate availability. I can resolve this issue within one hour. Let us have a quick discussion over the project so I can work on the job.

$20 USD 3 päivässä
(29 arvostelua)
4.6
gurramsunitha

 Over 7 years of IT experience in various domains as Developer that includes Database Design and Development, Microsoft BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SQL Server Lisää

$20 USD 1 päivässä
(1 arvostelu)
0.6
Monta2806

Hello! I have read your description and I can do your project perfectly. I am good experience in SQL. I can do your project in time and I can provide you full service. Looking forward your reply. Thanks.

$30 USD 1 päivässä
(0 arvostelua)
0.0
malikbilal15

Hi I will solve your sms issue regarding language. I can do this right now. let me share website details. regards bilal

$50 USD 1 päivässä
(0 arvostelua)
0.0
codebid88graham1

Hi dear, I have 6+years of rich experience with several complex and easy projects alone or with a team, I liked your project details and already done and completed successfully with an UK clients offsite. Please share Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0
khaldalfalah

I understand your request and happy to help you to finish it. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of Syria-Aleppo - year 2006. Programming and database spe Lisää

$30 USD 7 päivässä
(0 arvostelua)
0.0
aap31374

I have more then 15 years of experience in DBMS and immediately available. Lets chat and resolve it

$25 USD 1 päivässä
(0 arvostelua)
0.0
wdoyle2

Your issue is the collation of your database column. Ideally you'd need to be using utf8mb4 which would support your arabic characters but also emojis

$25 USD 1 päivässä
(0 arvostelua)
0.0
NooruddinDar

I would like to suggest some change in the code and it will work. I have done this with the Urdu language

$20 USD 7 päivässä
(0 arvostelua)
0.0
manishiec2013

I have earlier do this type of work

$25 USD 1 päivässä
(0 arvostelua)
0.0