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 >
