Hi
Always CC users list so you might get more feedback and others can benefit
from conversation.
What I mean was that you need to urlecode() your text when entering it into
sqlbox in order to "escape" characters that might cause some issues. In
mysql, the ' sign have an specific meaning. therefore if you need an ' into
your data, you can't insert it as ' but need to escape it or urlencode it.
This urlencode or escape make them "invisible" to the mysql engine and it
will handle them as standard characters and not as special chars.
You need to do something like:
$y = "mytext with an ' included"
$y = urlecode($y)
insert $y into sqlbox table
Actually it is safer to urlencode any char field data you might need to
insert onto your database. Not only the message field.
Regards
Alvaro
|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
Visitenos en www.perusms.com
2016-11-22 11:19 GMT-05:00 SANJEEV REDDY <sanjeevreddy...@gmail.com>:
> hello,
> Thank you very much for your reply. Can you please explain in detail.
> I am able to send the same sms by using smsbox but not with sql box.
>
> On Tue, Nov 22, 2016 at 7:19 PM, Alvaro Cornejo <cornejo.alv...@gmail.com>
> wrote:
>
>> Hi
>>
>> You need to url encode your string.
>>
>> Regards
>>
>> Alvaro
>>
>> |-----------------------------------------------------------
>> ------------------------------------------------------|
>> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
>> celular y Nextel
>> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
>> SMS y GPRS online
>> Visitenos en www.perusms.com
>>
>> 2016-11-22 6:19 GMT-05:00 SANJEEV REDDY <sanjeevreddy...@gmail.com>:
>>
>>> Hi all,
>>> When I tried to send sms containing single quotes from sql box,
>>> Opensmppbox logged the following error
>>> ERROR: Mallformed UDH length indicator 0x040 while message length 0x010.
>>> Discarding MO message.
>>>
>>> Example sms (msgdata) is sanj'dfsd'sdfsd.
>>>
>>> If I remove single quotes from the sms , it works fine.
>>> Please help me to understand the problem and share solution if you have
>>> one.
>>>
>>> Thanks in advance
>>>
>>>
>>> --
>>> *Thanks & regards,*
>>> *CHINTHAKUNTA SANJEEV,*
>>>
>>> *NA12B008,*
>>> *final year undergraduate,*
>>> *Dept. of Naval Architecture and Ocean Engg.,*
>>> *IIT Madras,*
>>>
>>> *Chennai-36,*
>>> *Ph no.+919043808647 <%2B919043808647>.*
>>>
>>
>>
>
>
> --
> *regards,*
> *CHINTHAKUNTA SANJEEV,*
>
> *NA12B008,*
> *final year undergraduate,*
> *Dept. of Naval Architecture and Ocean Engg.,*
> *IIT Madras,*
>
> *Chennai-36,*
> *Ph no.+919043808647 <%2B919043808647>.*
>
