Send sms with national characters with SQLBOX (MS SQL)

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Send sms with national characters with SQLBOX (MS SQL)

Dmitry Gorbunov

Hello all,

Have trouble to send sms via SQLbox (inserting them directly into send_sms table of MS SQL). I need to send sms with national characters (cyrilic, latvian).
I try this inserts:

INSERT INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[charset])
     VALUES('MT','iR','370000000','test тест',2,'clickatell','utf-8')
GO

or this

INSERT INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding])
     VALUES('MT','iR','370000000','test тест',2,'clickatell', 2)
GO

or this

INSERT INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding],[charset])
     VALUES('MT','iR','370000000','test тест',2,'clickatell', 2,'utf-8')
GO

nothing helps, cyrilic text arrives like ????

Data Type of fields msgdata of both tables are text and DB collation is default  SQL_Latin1_General_CP1_CI_AS.
Kannel version 1.4.4 and SQLBox version is  0.7.2 installed on SLES12 sp1

Anyone have expirience to configure SQLbox with MS SQL? any suggestions whats wrong?

Regards,
Dmitry

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Send sms with national characters with SQLBOX (MS SQL)

Vangelis Typaldos

Text must be url-encoded. Instead of test тест use test%20%D1%82%D0%B5%D1%81%D1%82


Regards,
V.


From: users <[hidden email]> on behalf of Dmitry Gorbunov <[hidden email]>
Sent: Wednesday, February 1, 2017 11:26 AM
To: kannel users
Subject: Send sms with national characters with SQLBOX (MS SQL)
 

Hello all,

Have trouble to send sms via SQLbox (inserting them directly into send_sms table of MS SQL). I need to send sms with national characters (cyrilic, latvian).
I try this inserts:

INSERT INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[charset])
     VALUES('MT','iR','370000000','test тест',2,'clickatell','utf-8')
GO

or this

INSERT INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding])
     VALUES('MT','iR','370000000','test тест',2,'clickatell', 2)
GO

or this

INSERT INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding],[charset])
     VALUES('MT','iR','370000000','test тест',2,'clickatell', 2,'utf-8')
GO

nothing helps, cyrilic text arrives like ????

Data Type of fields msgdata of both tables are text and DB collation is default  SQL_Latin1_General_CP1_CI_AS.
Kannel version 1.4.4 and SQLBox version is  0.7.2 installed on SLES12 sp1

Anyone have expirience to configure SQLbox with MS SQL? any suggestions whats wrong?

Regards,
Dmitry

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Send sms with national characters with SQLBOX (MS SQL)

Dmitry Gorbunov

Thank you Vangelis,

But still no success. I try all variants, with and without coding=2 with or without charset=utf-8, without any coding or charset only url-encoded text that you provided - only ???? symbols inplace of cyrilic

Regards,
Dmitry

Inactive hide details for Vangelis Typaldos ---01.02.2017 11:36:33---Text must be url-encoded. Instead of test ???? use test%20Vangelis Typaldos ---01.02.2017 11:36:33---Text must be url-encoded. Instead of test ???? use test%20%D1%82%D0%B5%D1%81%D1%82 Regards,

From: Vangelis Typaldos <[hidden email]>
To: Dmitry Gorbunov <[hidden email]>, kannel users <[hidden email]>
Date: 01.02.2017 11:36
Subject: Re: Send sms with national characters with SQLBOX (MS SQL)





Text must be url-encoded. Instead of test тест use test%20%D1%82%D0%B5%D1%81%D1%82


Regards,
V.



From: users <[hidden email]> on behalf of Dmitry Gorbunov <[hidden email]>
Sent:
 Wednesday, February 1, 2017 11:26 AM
To:
 kannel users
Subject:
 Send sms with national characters with SQLBOX (MS SQL)
 
Hello all,

Have trouble to send sms via SQLbox (inserting them directly into send_sms table of MS SQL). I need to send sms with national characters (cyrilic, latvian).
I try this inserts:


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[charset])
   
VALUES('MT','iR','370000000','test тест',2,'clickatell','utf-8')
GO


or this


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding])
   
VALUES('MT','iR','370000000','test тест',2,'clickatell', 2)
GO


or this


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding],[charset])
   
VALUES('MT','iR','370000000','test тест',2,'clickatell', 2,'utf-8')
GO


nothing helps, cyrilic text arrives like ????


Data Type of fields msgdata of both tables are text and DB collation is default  SQL_Latin1_General_CP1_CI_AS.
Kannel version 1.4.4 and SQLBox version is  0.7.2 installed on SLES12 sp1


Anyone have expirience to configure SQLbox with MS SQL? any suggestions whats wrong?


Regards,
Dmitry


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Send sms with national characters with SQLBOX (MS SQL)

Vangelis Typaldos



Try to identify from the submit_sm PDU from bearerbox.log the dcs values and the characters that actually send kannel in the pdu.


I would suggest to also try with sendsmsurl (without sqlbox)

http://localhost:PORT/cgi-bin/sendsms?username=USER&password=PASS&from=FROM&to=TO&smsc=SMSCID&text=test%20%D1%82%D0%B5%D1%81%D1%82 &coding=2&charset=UTF-8

in order to exclude that the issue is related with sqlbox


BR




From: Dmitry Gorbunov <[hidden email]>
Sent: Wednesday, February 1, 2017 11:49 AM
To: Vangelis Typaldos
Cc: kannel users
Subject: Re: Send sms with national characters with SQLBOX (MS SQL)
 

Thank you Vangelis,

But still no success. I try all variants, with and without coding=2 with or without charset=utf-8, without any coding or charset only url-encoded text that you provided - only ???? symbols inplace of cyrilic

Regards,
Dmitry

Vangelis Typaldos ---01.02.2017 11:36:33---Text must be url-encoded. Instead of test ???? use test%20%D1%82%D0%B5%D1%81%D1%82 Regards,

From: Vangelis Typaldos <[hidden email]>
To: Dmitry Gorbunov <[hidden email]>, kannel users <[hidden email]>
Date: 01.02.2017 11:36
Subject: Re: Send sms with national characters with SQLBOX (MS SQL)





Text must be url-encoded. Instead of test тест use test%20%D1%82%D0%B5%D1%81%D1%82


Regards,
V.



From: users <[hidden email]> on behalf of Dmitry Gorbunov <[hidden email]>
Sent:
 Wednesday, February 1, 2017 11:26 AM
To:
 kannel users
Subject:
 Send sms with national characters with SQLBOX (MS SQL)
 
Hello all,

Have trouble to send sms via SQLbox (inserting them directly into send_sms table of MS SQL). I need to send sms with national characters (cyrilic, latvian).
I try this inserts:


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[charset])
   
VALUES('MT','iR','370000000','test тест',2,'clickatell','utf-8')
GO


or this


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding])
   
VALUES('MT','iR','370000000','test тест',2,'clickatell', 2)
GO


or this


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding],[charset])
   
VALUES('MT','iR','370000000','test тест',2,'clickatell', 2,'utf-8')
GO


nothing helps, cyrilic text arrives like ????


Data Type of fields msgdata of both tables are text and DB collation is default  SQL_Latin1_General_CP1_CI_AS.
Kannel version 1.4.4 and SQLBox version is  0.7.2 installed on SLES12 sp1


Anyone have expirience to configure SQLbox with MS SQL? any suggestions whats wrong?


Regards,
Dmitry


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Send sms with national characters with SQLBOX (MS SQL)

Dmitry Gorbunov

DCS value you mean data_coding? it's data_coding: 216 = 0x000000d8 and short_message: "test ????"
From web browser all works fine, i check this previously

Ar cieņu / С уважением / Best Regards
Dmitry Gorbunov
IS administrator

Phone: +371 67025510 (ext. 1651)
Mobile: +371 26555413

Inactive hide details for Vangelis Typaldos ---01.02.2017 12:17:38---Try to identify from the submit_sm PDU from bearerbox.log Vangelis Typaldos ---01.02.2017 12:17:38---Try to identify from the submit_sm PDU from bearerbox.log the dcs values and the characters that act

From: Vangelis Typaldos <[hidden email]>
To: Dmitry Gorbunov <[hidden email]>
Cc: kannel users <[hidden email]>
Date: 01.02.2017 12:17
Subject: Re: Send sms with national characters with SQLBOX (MS SQL)







Try to identify from the submit_sm PDU from bearerbox.log the dcs values and the characters that actually send kannel in the pdu.

I would suggest to also try with sendsmsurl (without sqlbox)
<a href="http://localhost:PORT/cgi-bin/sendsms?username=USER&password=PASS&from=FROM&to=TO&smsc=SMSCID&text=">http://localhost:PORT/cgi-bin/sendsms?username=USER&password=PASS&from=FROM&to=TO&smsc=SMSCID&text=test%20%D1%82%D0%B5%D1%81%D1%82 &coding=2&charset=UTF-8
in order to exclude that the issue is related with sqlbox

BR





From: Dmitry Gorbunov <[hidden email]>
Sent:
 Wednesday, February 1, 2017 11:49 AM
To:
 Vangelis Typaldos
Cc:
 kannel users
Subject:
 Re: Send sms with national characters with SQLBOX (MS SQL) 
 
Thank you Vangelis,

But still no success. I try all variants, with and without coding=2 with or without charset=utf-8, without any coding or charset only url-encoded text that you provided - only ???? symbols inplace of cyrilic

Regards,
Dmitry

Inactive hide details for Vangelis Typaldos ---01.02.2017 11:36:33---Text must be url-encoded. Instead of test ???? use test%20Vangelis Typaldos ---01.02.2017 11:36:33---Text must be url-encoded. Instead of test ???? use test%20%D1%82%D0%B5%D1%81%D1%82 Regards,

From:
Vangelis Typaldos <[hidden email]>
To:
Dmitry Gorbunov <[hidden email]>, kannel users <[hidden email]>
Date:
01.02.2017 11:36
Subject:
Re: Send sms with national characters with SQLBOX (MS SQL)





Text must be url-encoded. Instead of test тест use test%20%D1%82%D0%B5%D1%81%D1%82


Regards,
V.



From:
 users <[hidden email]> on behalf of Dmitry Gorbunov <[hidden email]>
Sent:
 Wednesday, February 1, 2017 11:26 AM
To:
 kannel users
Subject:
 Send sms with national characters with SQLBOX (MS SQL)

Hello all,

Have trouble to send sms via SQLbox (inserting them directly into send_sms table of MS SQL). I need to send sms with national characters (cyrilic, latvian).
I try this inserts:


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[charset])
   
VALUES('MT','iR','370000000','test тест',2,'clickatell','utf-8')
GO


or this


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding])
   
VALUES('MT','iR','370000000','test тест',2,'clickatell', 2)
GO


or this


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding],[charset])
   
VALUES('MT','iR','370000000','test тест',2,'clickatell', 2,'utf-8')
GO


nothing helps, cyrilic text arrives like ????

Data Type of fields msgdata of both tables are text and DB collation is default  SQL_Latin1_General_CP1_CI_AS.
Kannel version 1.4.4 and SQLBox version is  0.7.2 installed on SLES12 sp1

Anyone have expirience to configure SQLbox with MS SQL? any suggestions whats wrong?

Regards,
Dmitry

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Send sms with national characters with SQLBOX (MS SQL)

Vangelis Typaldos
In reply to this post by Dmitry Gorbunov

data_coding (dcs) seems incorrect. I would suggest you to follow the indications provided in http://www.kannel.org/pipermail/devel/2012-January/004793.html

Probably MSSQL uses 0 as default value for the unspecified columns

 

Regards,

V.

 

From: [hidden email]
Sent: Wednesday, February 1, 2017 12:46 PM
To: [hidden email]
Cc: [hidden email]
Subject: Re: Send sms with national characters with SQLBOX (MS SQL)

 

DCS value you mean data_coding? it's data_coding: 216 = 0x000000d8 and short_message: "test ????"
From web browser all works fine, i check this previously

Ar cieņu / С уважением / Best Regards
Dmitry Gorbunov
IS administrator
cid:0__=4DBB0A29DFA971D48f9e8a93df938@rietumu.lv
Phone: +371 67025510 (ext. 1651)
Mobile: +371 26555413

Inactive hide details for Vangelis Typaldos ---01.02.2017 12:17:38---Try to identify from the submit_sm PDU from bearerbox.log Vangelis Typaldos ---01.02.2017 12:17:38---Try to identify from the submit_sm PDU from bearerbox.log the dcs values and the characters that act

From: Vangelis Typaldos <[hidden email]>
To: Dmitry Gorbunov <[hidden email]>
Cc: kannel users <[hidden email]>
Date: 01.02.2017 12:17
Subject: Re: Send sms with national characters with SQLBOX (MS SQL)






Try to identify from the submit_sm PDU from bearerbox.log the dcs values and the characters that actually send kannel in the pdu.

I would suggest to also try with sendsmsurl (without sqlbox)
<a href="http://localhost:PORT/cgi-bin/sendsms?username=USER&amp;password=PASS&amp;from=FROM&amp;to=TO&amp;smsc=SMSCID&amp;text=">http://localhost:PORT/cgi-bin/sendsms?username=USER&password=PASS&from=FROM&to=TO&smsc=SMSCID&text=test%20%D1%82%D0%B5%D1%81%D1%82 &coding=2&charset=UTF-8
in order to exclude that the issue is related with sqlbox

BR

 


From: Dmitry Gorbunov <[hidden email]>
Sent:
 Wednesday, February 1, 2017 11:49 AM
To:
 Vangelis Typaldos
Cc:
 kannel users
Subject:
 Re: Send sms with national characters with SQLBOX (MS SQL)
 
 
Thank you Vangelis,

But still no success. I try all variants, with and without coding=2 with or without charset=utf-8, without any coding or charset only url-encoded text that you provided - only ???? symbols inplace of cyrilic

Regards,
Dmitry

Inactive hide details for Vangelis Typaldos ---01.02.2017 11:36:33---Text must be url-encoded. Instead of test ???? use test%20Vangelis Typaldos ---01.02.2017 11:36:33---Text must be url-encoded. Instead of test ???? use test%20%D1%82%D0%B5%D1%81%D1%82 Regards,

From:
Vangelis Typaldos <[hidden email]>
To:
Dmitry Gorbunov <[hidden email]>, kannel users <[hidden email]>
Date:
01.02.2017 11:36
Subject:
Re: Send sms with national characters with SQLBOX (MS SQL)




Text must be url-encoded. Instead of test тест use test%20%D1%82%D0%B5%D1%81%D1%82


Regards,
V.


From:
 users <[hidden email]> on behalf of Dmitry Gorbunov <[hidden email]>
Sent:
 Wednesday, February 1, 2017 11:26 AM
To:
 kannel users
Subject:
 Send sms with national characters with SQLBOX (MS SQL)


Hello all,

Have trouble to send sms via SQLbox (inserting them directly into send_sms table of MS SQL). I need to send sms with national characters (cyrilic, latvian).
I try this inserts:


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[charset])
   VALUES('MT','iR','370000000','test тест',2,'clickatell','utf-8')
GO


or this


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding])
   VALUES('MT','iR','370000000','test тест',2,'clickatell', 2)
GO


or this


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding],[charset])
   VALUES('MT','iR','370000000','test тест',2,'clickatell', 2,'utf-8')
GO


nothing helps, cyrilic text arrives like ????

Data Type of fields msgdata of both tables are text and DB collation is default  SQL_Latin1_General_CP1_CI_AS.
Kannel version 1.4.4 and SQLBox version is  0.7.2 installed on SLES12 sp1

Anyone have expirience to configure SQLbox with MS SQL? any suggestions whats wrong?

Regards,
Dmitry

 

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Send sms with national characters with SQLBOX (MS SQL)

Dmitry Gorbunov

In sent_sms table i see NULL in not specified fields but in some of them 0 indeed.
I try to make insert with all field specification but i don't get correct combination to set DCS in right state. By the way, which stat is correct 0? 1? Manipulating with dlr_mask 31 i get 0 in dcs, but provider send me an error. How to set dcs in 1?

Ar cieņu / С уважением / Best Regards
Dmitry Gorbunov
IS administrator

Phone: +371 67025510 (ext. 1651)
Mobile: +371 26555413

Inactive hide details for Vangelis Typaldos ---01.02.2017 14:02:35---data_coding (dcs) seems incorrect. I would suggest you to Vangelis Typaldos ---01.02.2017 14:02:35---data_coding (dcs) seems incorrect. I would suggest you to follow the indications provided in http://

From: Vangelis Typaldos <[hidden email]>
To: Dmitry Gorbunov <[hidden email]>
Cc: kannel users <[hidden email]>
Date: 01.02.2017 14:02
Subject: RE: Send sms with national characters with SQLBOX (MS SQL)





data_coding (dcs) seems incorrect. I would suggest you to follow the indications provided in http://www.kannel.org/pipermail/devel/2012-January/004793.html 
Probably MSSQL uses 0 as default value for the unspecified columns
 
Regards,
V.
 
From: [hidden email]
Sent:
Wednesday, February 1, 2017 12:46 PM
To:
[hidden email]
Cc:
[hidden email]
Subject:
Re: Send sms with national characters with SQLBOX (MS SQL)
 

DCS value you mean data_coding? it's data_coding: 216 = 0x000000d8 and short_message: "test ????"
From web browser all works fine, i check this previously


Ar cieņu / С уважением / Best Regards
Dmitry Gorbunov
IS administrator

cid:0__=4DBB0A29DFA971D48f9e8a93df938@rietumu.lv
Phone: +371 67025510 (ext. 1651)
Mobile: +371 26555413


Inactive hide details for Vangelis Typaldos ---01.02.2017 12:17:38---Try to identify from the submit_sm PDU from bearerbox.log Vangelis Typaldos ---01.02.2017 12:17:38---Try to identify from the submit_sm PDU from bearerbox.log the dcs values and the characters that act

From:
Vangelis Typaldos <[hidden email]>
To:
Dmitry Gorbunov <[hidden email]>
Cc:
kannel users <[hidden email]>
Date:
01.02.2017 12:17
Subject:
Re: Send sms with national characters with SQLBOX (MS SQL)






Try to identify from the submit_sm PDU from bearerbox.log the dcs values and the characters that actually send kannel in the pdu.

I would suggest to also try with sendsmsurl (without sqlbox)

<a href="http://localhost:port/cgi-bin/sendsms?username=USER&password=PASS&from=FROM&to=TO&smsc=SMSCID&text=">http://localhost:PORT/cgi-bin/sendsms?username=USER&password=PASS&from=FROM&to=TO&smsc=SMSCID&text=test%20%D1%82%D0%B5%D1%81%D1%82 &coding=2&charset=UTF-8
in order to exclude that the issue is related with sqlbox

BR

 


From:
 Dmitry Gorbunov <[hidden email]>
Sent:
 Wednesday, February 1, 2017 11:49 AM
To:
 Vangelis Typaldos
Cc:
 kannel users
Subject:
 Re: Send sms with national characters with SQLBOX (MS SQL)

Thank you Vangelis,

But still no success. I try all variants, with and without coding=2 with or without charset=utf-8, without any coding or charset only url-encoded text that you provided - only ???? symbols inplace of cyrilic

Regards,
Dmitry

Inactive hide details for Vangelis Typaldos ---01.02.2017 11:36:33---Text must be url-encoded. Instead of test ???? use test%20Vangelis Typaldos ---01.02.2017 11:36:33---Text must be url-encoded. Instead of test ???? use test%20%D1%82%D0%B5%D1%81%D1%82 Regards,

From:
Vangelis Typaldos <[hidden email]>
To:
Dmitry Gorbunov <[hidden email]>, kannel users <[hidden email]>
Date:
01.02.2017 11:36
Subject:
Re: Send sms with national characters with SQLBOX (MS SQL) 




Text must be url-encoded. Instead of test тест use test%20%D1%82%D0%B5%D1%81%D1%82

Regards,
V.



From:
 users <[hidden email]> on behalf of Dmitry Gorbunov <[hidden email]>
Sent:
 Wednesday, February 1, 2017 11:26 AM
To:
 kannel users
Subject:
 Send sms with national characters with SQLBOX (MS SQL)

Hello all,

Have trouble to send sms via SQLbox (inserting them directly into send_sms table of MS SQL). I need to send sms with national characters (cyrilic, latvian).
I try this inserts:


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[charset])
 
VALUES('MT','iR','370000000','test тест',2,'clickatell','utf-8')
GO


or this


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding])
 
VALUES('MT','iR','370000000','test тест',2,'clickatell', 2)
GO


or this


INSERT
 INTO [KANNEL].[dbo].[send_sms]([momt],[sender],[receiver],[msgdata],[sms_type],[smsc_id],[coding],[charset])
 
VALUES('MT','iR','370000000','test тест',2,'clickatell', 2,'utf-8')
GO


nothing helps, cyrilic text arrives like ????

Data Type of fields msgdata of both tables are text and DB collation is default  SQL_Latin1_General_CP1_CI_AS.
Kannel version 1.4.4 and SQLBox version is  0.7.2 installed on SLES12 sp1

Anyone have expirience to configure SQLbox with MS SQL? any suggestions whats wrong?

Regards,
Dmitry

 
[attachment "10713760.gif" deleted by Dmitry Gorbunov/Rietumu Banka] [attachment "graycol.gif" deleted by Dmitry Gorbunov/Rietumu Banka]

Loading...