Hi,
I followed your instructions. It works fine now. Thanks a lot for
sharing your knowledge.
On Tue, Nov 22, 2016 at 10:11 PM, Alvaro Cornejo <cornejo.alv...@gmail.com>
wrote:
> 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>.*
>>
>
>
--
*regards,*
*CHINTHAKUNTA SANJEEV,*
*NA12B008,*
*final year undergraduate,*
*Dept. of Naval Architecture and Ocean Engg.,*
*IIT Madras,*
*Chennai-36,*
*Ph no.+919043808647.*
