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 To: users 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
