Hi Try to urlencode the url before inserting ir to send_sms
Regards Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com On Wed, May 21, 2014 at 11:44 PM, خان ابو زید <khan.abuz...@gmail.com> wrote: > utf8_general_ci > > direct entry into send_sms table without urlencoding. > set charset=UTF-8 > > > On Wed, May 21, 2014 at 8:05 PM, Alvaro Cornejo <cornejo.alv...@gmail.com> > wrote: >> >> Hi >> >> garbage on url... seems it is not recognizing url charset/encode >> format. Have you urlencoded it before submitting to sqlbox? what >> charset do you use when submitting info to sql and what charset is >> defined on mysql table? >> >> Regards >> >> Alvaro >> >> |-----------------------------------------------------------------------------------------------------------------| >> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier >> celular y Nextel >> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via >> SMS y GPRS online >> Visitenos en www.perusms.com >> >> >> On Wed, May 21, 2014 at 3:49 AM, خان ابو زید <khan.abuz...@gmail.com> >> wrote: >> > Dear Member, >> > >> > I have installed kannel sqlbox from svn latest version. >> > >> > I have getting following error in sqlbox >> > >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] ERROR: MYSQL: You have an error in your >> > SQL >> > synta x; check the manual >> > that >> > corresponds to your MySQL server version for the right >> > syntax to use near '' at line 1 >> > 2014-05-21 06:03:09 [3793] [1] ERROR: MYSQL: You have an error in your >> > SQL >> > synta x; check the manual >> > that >> > corresponds to your MySQL server version for the right >> > syntax to use near ')' at line 1 >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] WARNING: octstr_url_decode: garbage >> > detected >> > (% d ) skipping. >> > 2014-05-21 06:03:09 [3793] [1] ERROR: Could not charset process message, >> > droppin g it! >> > 2014-05-21 06:03:09 [3793] [1] ERROR: MYSQL: You have an error in your >> > SQL >> > synta x; check the manual >> > that >> > corresponds to your MySQL server version for the right >> > syntax to use near '' at line 1 >> > 2014-05-21 06:03:09 [3793] [1] ERROR: MYSQL: You have an error in your >> > SQL >> > synta x; check the manual >> > that >> > corresponds to your MySQL server version for the right >> > syntax to use near ')' at line 1 >> > >> > -- >> > Regards >> > >> > Khan Abuzaid >> > Mob# :09664541886/9594092200 >> > Mumbai > > > > > -- > Regards > > Khan Abuzaid > Mob# :09664541886/9594092200 > Mumbai