Hi
I guess both tables are on the same database; What is the default charset
of your tables? are they the same?
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
On Tue, Oct 28, 2014 at 1:57 AM, MOSES KARIUKI <kariuk...@gmail.com> wrote:
> Hi Rajeev,
>
> Thanks for your assistance. Much appreciated.
>
> This is the scenario. I have Sqlbox connected to Kannel. I am using it to
> send messages to an external SMSC by inserting messages directly into the
> send_sms table of SQLBOX, which in-turn send out the messages. It is
> working OK with English Alphabet characters, but when I insert French
> characters to the send_sms table of SQLBOX, using the command (
> INSERT INTO send_sms (charset,coding,momt, sender, receiver,dlr_url,
> msg_text)
> VALUES ('utf-8',2,'MT', '8008' ,'+25463232333', 'http://url', 'test déjà')
> ) the characters are corrupted and this is what appears.
> "Test+d%C3%A9j%C3%A0"
>
> To test if database encoding is working : i tried the command below on a
> test table called tbl_outgoing,
> INSERT into tbl_outgoing (msg_text) values ( 'test déjà');
> it works fine.
> Select msg_text from tbl_outgoing ;
> result is :
> *msg_text *
> 'test déjà'
>
> Why is SQLBOX's insertion of French characters not working?
>
> Thanks a lot for your assistance. Much appreciated.
>
> Moses
>
> On Mon, Oct 27, 2014 at 6:44 PM, RK Krishnas <r...@krishnasoft.in> wrote:
>
>> Hi,
>>
>> Please clearly specify the process.
>> I'm Confused at tbl_outgoing & send_sms.
>> where & how are you inserting sms & in to which table.
>> All sms has to be url encoded before inserting into sqlbox "send_sms"
>> table
>> for unicode sms coding has to be "2".
>>
>>
>> *Rajeev Krishna*
>>
>> Operations Manager
>> Krishnas Software Technologies
>> www.krishnasoft.in
>> mobile :+91 888 5815 888
>> Sales :+91 888 5813 888
>> Support :+91 888 5817 888
>>
>> On Mon, Oct 27, 2014 at 7:05 PM, MOSES KARIUKI <kariuk...@gmail.com>
>> wrote:
>>
>>> Hi Rajeev,
>>>
>>>
>>> When I do this :
>>> INSERT into tbl_outgoing (msg_text) values ( 'test déjà');
>>> it works fine.
>>>
>>> but when I do:
>>> INSERT INTO send_sms (charset,coding,momt, sender,
>>> receiver,dlr_url,msg_text)
>>> VALUES ('utf-8',2,'MT', '8008' ,'+25463232333', 'http://url','test
>>> déjà')
>>>
>>> this ,"Test+d%C3%A9j%C3%A0", is the value that is inserted in SENT_SMS
>>> table of sql box.
>>>
>>> I am doing a direct insert using sql code.
>>>
>>> Thanks,
>>> Moses
>>>
>>> On Mon, Oct 27, 2014 at 4:17 PM, RK Krishnas <r...@krishnasoft.in> wrote:
>>>
>>>> HI,
>>>>
>>>> have you url-enoded the sms text before inserting into sqlbox send_sms
>>>> table ???
>>>>
>>>>
>>>> *Rajeev Krishna*
>>>>
>>>> Operations Manager
>>>> Krishnas Software Technologies
>>>> www.krishnasoft.in
>>>> mobile :+91 888 5815 888
>>>> Sales :+91 888 5813 888
>>>> Support :+91 888 5817 888
>>>>
>>>> On Mon, Oct 27, 2014 at 6:35 PM, MOSES KARIUKI <kariuk...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi Team,
>>>>>
>>>>> I am trying to send a text / sms that has French Characters (Test
>>>>> déjà) using sqlbox but the text always gets corrupted. I have checked and
>>>>> I
>>>>> can insert the same to my postgres database that has utf-8 encoding.
>>>>>
>>>>> I have also tried setting coding=2 and charset='UTF-8' in send SMS but
>>>>> no luck.
>>>>>
>>>>> Please assist.
>>>>>
>>>>> Thanks,
>>>>> MK
>>>>>
>>>>
>>>>
>>>
>>
>
