RE: Help with Unicode Messages

[Davor Spasoski]

BTW, I don’t know why the cgi-bin was slow on you. We’ve sent bilions of SMS so 
far and there was not a single problem with the smsbox

What are you using to address to the smsbox?

Davor Spasoski

From: users  On Behalf Of Davor Spasoski
Sent: Friday, March 20, 2020 12:34 PM
To: Gabriel Augusto Diaz Zapata 
Cc: users@kannel.org
Subject: RE: Help with Unicode Messages


1.Your table must be created with Unicode support

2.select encoding/collation to UTF8mb4

3.If you are using a programming language, set the connection to the table 
must be with the proper (UTF-8) charset.

4.If you use SQL statement from the CLI, make sure the CLI supports UTF8mb4

5.Copy/paste the smiley sign or follow the link here 
https://stackoverflow.com/questions/39463134/how-to-store-emoji-character-in-mysql-database


Davor Spasoski

From: Gabriel Augusto Diaz Zapata 
mailto:gabriel.d...@gmail.com>>
Sent: Friday, March 20, 2020 5:30 AM
To: Davor Spasoski mailto:davor.spaso...@a1.mk>>
Cc: users@kannel.org
Subject: Re: Help with Unicode Messages

Yes, I did.

So.. change my question
I need to send some millions of unicode messages
I tried with smsbox cgi, but I  didnt get a better performance.. some timeouts 
or very slow..

So.. I think to do a bulk insert to send_sms table, but i need to identify how 
is encoded the HMTL Entities, in example " Hello " to  
%00h%00e%00l%00l%00o%00%A0%D8%3D%DE%00 (bold text is the emoji)
I need to know please how to encode the text  and the UNICODE text

It is possible?

Thanks in advanced

On Thu, Mar 19, 2020 at 3:31 AM Davor Spasoski 
mailto:davor.spaso...@a1.mk>> wrote:
Did you set coding=2

On Mar 19, 2020, at 04:42, Gabriel Augusto Diaz Zapata 
mailto:gabriel.d...@gmail.com>> wrote:

Tks Davor, Antony

URL Encoded doesnt works.. The string after conversion is not the same

On Wed, Mar 18, 2020 at 4:49 AM Davor Spasoski 
mailto:davor.spaso...@a1.mk>> wrote:
Hi,

You need to address to smsbox in UTF-8. So, you then URL encode (percent 
encode) every hex code of the UTF-8 sign.

BR,
Davor

> On Mar 18, 2020, at 02:07, Gabriel Augusto Diaz Zapata 
> mailto:gabriel.d...@gmail.com>> wrote:
>
> Hello
> I need help please
>
> Im sending unicode messages (emojis) using sendsms. IE, xc; is converted in 
> sent_sms table to "%D8%3D%DE%00"
>
> Wich type of conversion is it? I mean UNICODE to? HEX?
>
> Thank you
>
> Gabriel




Disclaimer: A1 Makedonija DOOEL Skopje
This e-mail (including any attachments) is confidential and may be protected by 
legal privilege. If you are not the intended recipient, you should not copy it, 
re-transmit it, use it or disclose its contents, but should return it to the 
sender immediately and delete your copy from your system. Any unauthorized use 
or dissemination of this message in whole or in part is strictly prohibited. 
Please note that e-mails are susceptible to change. A1 Makedonija DOOEL Skopje 
shall not be liable for the improper or incomplete transmission of the 
information contained in this communication nor for any delay in its receipt or 
damage to your system.
Please, do not print this e-mail unless it is necessary! Think about saving the 
environment!

Напомена: А1 Македонија ДООЕЛ Скопје
Оваа електронска порака (вклучувајќи ги и прилозите) е доверлива и може да биде 
заштитена со правни привилегии. Доколку не сте лицето на кое таа му е наменета 
пораката, не треба да ја копирате, дистрибуирате или да ја откривате нејзината 
содржина, туку веднаш да ја препратите до испраќачот и да ја избришете 
оригиналната порака и сите нејзини копии од Вашиот компјутерски систем. Секое 
неовластено користење на оваа порака во целост или делови од истата е строго 
забрането. Ве молиме да забележите дека електронските пораки се подложни на 
промени. А1 Македонија ДООЕЛ Скопје не презема одговорност за несоодветно или 
нецелосно пренесување на информациите содржани во оваа комуникација, ниту пак 
за било какво задоцнување на приемот или оштетувања на вашиот систем.
Ве молиме не ја печатете оваа порака освен ако не е неопходно! Зачувајте ја 
природата!



Disclaimer: A1 Makedonija DOOEL Skopje
This e-mail (including any attachments) is confidential and may be protected by 
legal privilege. If you are not the intended recipient, you should not copy it, 
re-transmit it, use it or disclose its contents, but should return it to the 
sender immediately and delete your copy from your system. Any unauthorized use 
or dissemination of this message in whole or in part is strictly prohibited. 
Please note that e-mails are susceptible to change. A1 Makedonija DOOEL Skopje 
shall not be liable for the improper or incomplete transmission of the 
information contained in this communication nor for any delay in its receipt or 
damage to your system.
Please, do not print this e-mail unless it is necessary! Think about saving the 
environment!

Напомена: А1 Македонија ДООЕЛ Скопје

RE: Help with Unicode Messages

[Davor Spasoski]

1.Your table must be created with Unicode support

2.select encoding/collation to UTF8mb4

3.If you are using a programming language, set the connection to the table 
must be with the proper (UTF-8) charset.

4.If you use SQL statement from the CLI, make sure the CLI supports UTF8mb4

5.Copy/paste the smiley sign or follow the link here 
https://stackoverflow.com/questions/39463134/how-to-store-emoji-character-in-mysql-database


Davor Spasoski

From: Gabriel Augusto Diaz Zapata 
Sent: Friday, March 20, 2020 5:30 AM
To: Davor Spasoski 
Cc: users@kannel.org
Subject: Re: Help with Unicode Messages

Yes, I did.

So.. change my question
I need to send some millions of unicode messages
I tried with smsbox cgi, but I  didnt get a better performance.. some timeouts 
or very slow..

So.. I think to do a bulk insert to send_sms table, but i need to identify how 
is encoded the HMTL Entities, in example " Hello " to  
%00h%00e%00l%00l%00o%00%A0%D8%3D%DE%00 (bold text is the emoji)
I need to know please how to encode the text  and the UNICODE text

It is possible?

Thanks in advanced

On Thu, Mar 19, 2020 at 3:31 AM Davor Spasoski 
mailto:davor.spaso...@a1.mk>> wrote:
Did you set coding=2


On Mar 19, 2020, at 04:42, Gabriel Augusto Diaz Zapata 
mailto:gabriel.d...@gmail.com>> wrote:

Tks Davor, Antony

URL Encoded doesnt works.. The string after conversion is not the same

On Wed, Mar 18, 2020 at 4:49 AM Davor Spasoski 
mailto:davor.spaso...@a1.mk>> wrote:
Hi,

You need to address to smsbox in UTF-8. So, you then URL encode (percent 
encode) every hex code of the UTF-8 sign.

BR,
Davor

> On Mar 18, 2020, at 02:07, Gabriel Augusto Diaz Zapata 
> mailto:gabriel.d...@gmail.com>> wrote:
>
> Hello
> I need help please
>
> Im sending unicode messages (emojis) using sendsms. IE, xc; is converted in 
> sent_sms table to "%D8%3D%DE%00"
>
> Wich type of conversion is it? I mean UNICODE to? HEX?
>
> Thank you
>
> Gabriel




Disclaimer: A1 Makedonija DOOEL Skopje
This e-mail (including any attachments) is confidential and may be protected by 
legal privilege. If you are not the intended recipient, you should not copy it, 
re-transmit it, use it or disclose its contents, but should return it to the 
sender immediately and delete your copy from your system. Any unauthorized use 
or dissemination of this message in whole or in part is strictly prohibited. 
Please note that e-mails are susceptible to change. A1 Makedonija DOOEL Skopje 
shall not be liable for the improper or incomplete transmission of the 
information contained in this communication nor for any delay in its receipt or 
damage to your system.
Please, do not print this e-mail unless it is necessary! Think about saving the 
environment!

Напомена: А1 Македонија ДООЕЛ Скопје
Оваа електронска порака (вклучувајќи ги и прилозите) е доверлива и може да биде 
заштитена со правни привилегии. Доколку не сте лицето на кое таа му е наменета 
пораката, не треба да ја копирате, дистрибуирате или да ја откривате нејзината 
содржина, туку веднаш да ја препратите до испраќачот и да ја избришете 
оригиналната порака и сите нејзини копии од Вашиот компјутерски систем. Секое 
неовластено користење на оваа порака во целост или делови од истата е строго 
забрането. Ве молиме да забележите дека електронските пораки се подложни на 
промени. А1 Македонија ДООЕЛ Скопје не презема одговорност за несоодветно или 
нецелосно пренесување на информациите содржани во оваа комуникација, ниту пак 
за било какво задоцнување на приемот или оштетувања на вашиот систем.
Ве молиме не ја печатете оваа порака освен ако не е неопходно! Зачувајте ја 
природата!



Disclaimer: A1 Makedonija DOOEL Skopje
This e-mail (including any attachments) is confidential and may be protected by 
legal privilege. If you are not the intended recipient, you should not copy it, 
re-transmit it, use it or disclose its contents, but should return it to the 
sender immediately and delete your copy from your system. Any unauthorized use 
or dissemination of this message in whole or in part is strictly prohibited. 
Please note that e-mails are susceptible to change. A1 Makedonija DOOEL Skopje 
shall not be liable for the improper or incomplete transmission of the 
information contained in this communication nor for any delay in its receipt or 
damage to your system.
Please, do not print this e-mail unless it is necessary! Think about saving the 
environment!

Напомена: А1 Македонија ДООЕЛ Скопје
Оваа електронска порака (вклучувајќи ги и прилозите) е доверлива и може да биде 
заштитена со правни привилегии. Доколку не сте лицето на кое таа му е наменета 
пораката, не треба да ја копирате, дистрибуирате или да ја откривате нејзината 
содржина, туку веднаш да ја препратите до испраќачот и да ја избришете 
оригиналната порака и сите нејзини копии од Вашиот компјутерски систем. Секое 
неовластено користење на оваа порака во целост или делови од