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
