Forgot to mention, when I had the same problem as you, reinstalling sqlbox didn't help to me, I had to checkout kannel as well, because there was a bug.
2013/4/7 spameden <[email protected]> > 1. Why don't you want to checkout latest revision? There were plenty of > bugs fixed lately. > > 2. There was an error in the kannel uploaded on the site (version 1.5.0) > related to the encoding giving out exactly behavior you're getting. > > 3. No, you don't need to encode special way either, just a simple > urlencode procedure. > > 4. SQLBox might work with old kannel, but I don't recommend doing so, > better compile latest kannel and sqlbox, it's not that hard. > > > 2013/4/7 Ali Kashif <[email protected]> > >> >> 1. Using kennel 1.5, checkedout around mid of 2012 or bit late >> 2. I am inserting 'utf-8' ( without quots, lowercase) >> 3. Sure I will remove mo-recode >> 4. Yes . I am using php standard function urlencode();. Do I need some >> other way to encode data before inserting into sqlbox? >> >> >> My question is if I checkout only sqlbox now, will that work with >> previously downloaded kennel 1.5 and opensmpp >> >> >> >> >> On Sunday, April 7, 2013, spameden wrote: >> >>> 1. What's the version of kannel you're using? >>> >>> answering before you did - use latest from SVN (not from releases page, >>> i.e. compile yourself from latest revision!) >>> >>> 2. charset should be 'utf-8', exactly like that >>> >>> 3. no need to use mo-recode option, it works without it. >>> >>> 4. how do you urlencode via standard php function? >>> >>> >>> 2013/4/7 Ali Kashif <[email protected]> >>> >>>> I am Trying to insert MT message in sqlbox send_sms table, with >>>> >>>> msgdata = urlencoed data >>>> coding =2 >>>> charset= UTF-8 >>>> >>>> MYSQL : table , Database and msgData field is UTF-8 >>>> >>>> >>>> and in my kannel configuration i have added >>>> >>>> mo-recode=true >>>> >>>> >>>> (even though i am not sure why should i add this but this thread says .. >>>> http://comments.gmane.org/gmane.comp.mobile.kannel.user/20630) >>>> >>>> >>>> but end user is receiving BOXES in message >>>> >>>> >>>> I can send a perfect message using kannel using sendsms >>>> >>>> >>>> cgi-bin/sendsms?username=USER&password=12345&coding=2&charset=UTF-8&from=123&to=+XXXXXXXXXXXX&text=%C2%BFABC%E2%82%AC%40%21%26%25%C2%A7%3F%3F%C2%A1wxyz%C3%A4%C3%B6%C3%B1%C3%BC%C3%A0%3F%C3%9F%C3%A6%C3%86%7B%7D%5B%5D%28%2912345 >>>> >>>> >>>> >>>> >>>> i have gone through many articles and mailinglist but so far no solution . >>>> >>>> i have found these 2 links >>>> >>>> >>>> https://build.opensuse.org/package/view_file?file=sqlbox-r45-encoding-fix.diff&package=sqlbox&project=home%3Acrt0solutions%3Akannel >>>> >>>> >>>> >>>> >>>> http://www.kannel.org/pipermail/devel/2010-August/003892.html >>>> >>>> >>>> i am really not sure about the DIFF patch and really dont know how to >>>> apply that, on the other hand the second like seems promising but i dont >>>> know what the results will be for my case (Arabic and French Messages) >>>> >>>> >>>> so can anyone suggest me some solution for this ? >>>> >>>> Thanks >>>> >>>> Ali >>>> >>>> >>> >
