Hi. The whole database is UTG-8. UTF-8 is the default charset on both
tables.
On Oct 28, 2014 4:58 PM, "Alvaro Cornejo" <cornejo.alv...@gmail.com> wrote:
> 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
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>
