Thank you Nikos, But how can I configure kannel to call a stored procedure in mysql, I think this will help non programmers users.
TIA 2009/6/8 Nikos Balkanas <[email protected]> > You don't need smsbox to push SMS, if you have sqlbox. But you need it > for incoming SMS and sms services. > > BR, > Nikos > > ----- Original Message ----- > *From:* Benaiad <[email protected]> > *To:* users <[email protected]> > *Sent:* Saturday, June 06, 2009 10:05 PM > *Subject:* Re: SQLBox with utf8 chars > > Correction: > I've successfully implemented this scenario, But I need to know if I can > use this without the need of smsbox. > > Thanks! > > > On Sat, Jun 6, 2009 at 9:03 PM, Benaiad <[email protected]> wrote: > >> I've found this: >> 1- to convert from HEX to utf8 using mysql: >> SELECT CONVERT(UNHEX(msgdata) USING ucs2 )Β FROM sent_smsΒ WHERE sql_id >> = 14 AND coding = 2 >> >> 2- to convert from utf8 to HEX using mysql: >> SELECT HEX(CONVERT(myutf8string USING ucs2)Β ) >> >> Now I want to use bearerbox with sqlbox only: >> Every MO message will be saved in sent_sms table by sqlbox. >> And every INSERT into sent_sms table will call a trigger, the trigger will >> analyze the MO message and insert it's response into the send_sms table. >> I've successfully implemented this scenario, But I need to know if I can >> use this with the need of smsbox. >> >> Thanks guys for your kind response and special thanks to Alejandro >> Guerrieri for his great support and concern. >> >> Best Regards. >> >> Monim Benaiad >> > >
