Oh My God... That's it. Wrong version! I spent 16 hours on it...
Guys, you are really helpful, thank you so much. On Sat, May 14, 2011 at 12:03 AM, Rene Kluwen <rene.klu...@chimit.nl> wrote: > Yes, it gives an info. > > > > I just now downloaded 1.5.0 as well to see if there are any differences. > > And it seems that url-decoding the msgdata field was introduced after that > version. > > So try to use svn trunk revision. > > > > == Rene > > > > > > *From:* Tania Petsouka [mailto:ta...@tessera.gr] > *Sent:* Friday, 13 May, 2011 22:52 > *To:* Rene Kluwen > *Cc:* Mike Nakos; users@kannel.org > > *Subject:* Re: sqlbox greek gsm-7 > > > > I use Dev version, 1.5, - sqlbox included. > If it gives an info.. > > On Fri, May 13, 2011 at 11:43 PM, Tania Petsouka <ta...@tessera.gr> wrote: > > Last time, i copied it to be sure.. > > > > INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, dlr_mask, > coding) > > VALUES('MT', 'tan', '306937078135', '%00%10%12%13%14', 2, 31, 0); > > And i did it directly to the database.. > > > > On Fri, May 13, 2011 at 11:40 PM, Rene Kluwen <rene.klu...@chimit.nl> > wrote: > > Could you display the insert statement that you are using? > > It must be similar to the one that Mike suggested. > > > > =-= Rene > > > > > > *From:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On > Behalf Of *Tania Petsouka > *Sent:* Friday, 13 May, 2011 22:02 > > > *To:* Mike Nakos > *Cc:* users@kannel.org > > *Subject:* Re: sqlbox greek gsm-7 > > > > If i send url encoded chars like %00%10%12%13%14' from url , http request, > there is no problem at all. > The issue occurs only with sql box. So.. i tried to change table send_sms > to utf8, no luck. > I turned it back to latin. > Did you change default settings of send_sms table? > > 2011/5/13 Tania Petsouka <ta...@tessera.gr> > > I tried it, but i receive the exact string i insert to the database: > %00%10%12%13%14. > > short_message: "%00%10%12%13%14" > > Obviously, i have wrong settings somewhere... but my config is like yours.. > > Have you got any idea? > > > > 2011/5/13 Mike Nakos <mike.na...@gmail.com> > > You are wrong when you put to DB value 0x00 because this indicates the end > of the string. > You see, null terminated string. > You did also misunderstand the purpose of php hexdec() function. To make > this function work you should use it this way: > hexdec('00') > But this is not the point. D O N ' T use chr() function. > To correctly insert data to msgdata field and overcome the 0x00 (NULL > problem - which is not kannel's problem) is this: > > INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, dlr_mask, > coding) > VALUES('MT', 'mike', '3069112345', '%00%10%12%13%14', 2, 31, 0); > > And again, URL-ENCODE the characters > > Give it a shoot! > > > > > On 13/05/11 11:35, Πετσούκα Τάνια wrote: > > It didn't work. > > i replace '@' with chr(hexdec( '%00' )) > > If i send a message with text " u...@dom.com" , I receive "user" . > > In kannel logs too : short_message: "user". > > I've tried to send all gsm charecters, but none turned to '@'. > > I guess it may be represented by two chars, like euro, but i have no idea. > > '0x00' is the null character, so kannel confuses somewhere and thinks that > this is the end of the sms?? > > I was thinking that it might be SMSC's issue but it is not since logs from > submit_sm give short_message: "user" . > > Mike, if you really send '@' , could you send me a db insert for a message > with this symbol to try? > (ps: your patch for concatenation works perfectly) > > > > > > > ----- Original Message ----- From: "Mike Nakos" <mike.na...@gmail.com> > To: "Πετσούκα Τάνια" <ta...@tessera.gr> > Cc: <users@kannel.org> > Sent: Thursday, May 12, 2011 7:39 PM > Subject: Re: sqlbox greek gsm-7 > > Hi again. %00 is the answer. > All the alphabet is here: > http://en.wikipedia.org/wiki/GSM_03.38 > > Best regards > Mike Nakos > > On 12/05/11 14:08, Πετσούκα Τάνια wrote: > > Thank you Mike, > i send greek properly using your settings. > > The only problem i came up with is symbol '@'. > > E.g : For greek letter Phi, Φ, i use : chr(hexdec( '0x12' )) ( or > chr(hexdec( '%12') ) > For greek letter Lamda, Λ, i use : chr(hexdec( '0x14' )) ( or > chr(hexdec( '%14') ) > For euro sign ¤ i use : chr(hexdec('0x1B')).chr(hexdec('0x65')) > .....etc > > When it comes to '@' if i replace it to chr(hexdec( '0x00' )) according > to gsm mapping, > http://www.cardboardfish.com/support/bin/view/Main/GSMEncoding > the message after this character disappears. > I tried to replace it with chr(hexdec( '%40' )) , and i got 'i' in its > position to the received message. > > So, do you know which is the proper way to send '@'? > > > ----- Original Message ----- From: "Mike Nakos" <mike.na...@gmail.com> > To: <ta...@tessera.gr> > Cc: <users@kannel.org> > Sent: Wednesday, May 11, 2011 8:14 PM > Subject: Re: Re: sqlbox greek gsm-7 > > Hello Tania. > I use the below settings on my kannel.conf file > > group = smsc > smsc = smpp > smsc-id = <myprovider> > host = <ip address> > port = <smsc port> > receive-port = <smsc port> > smsc-username = <username> > smsc-password = <password> > source-addr-ton = 0 > source-addr-npi = 1 > dest-addr-ton = 1 > #dest-addr-np = 1 > bind-addr-ton = 0 > bind-addr-npi = 1 > system-type = "VMA" > enquire-link-interval = 30 > reconnect-delay = 10 > throughput = 20 > validityperiod = 1340 > alt-charset = "UTF-8" > > > I don't use alt_dcs and set charset field on sms_send table to UTF-8 also. > > Of course, any Greek character like Δ must be written %10 to msgdata field. > Personally, I encode every single character to its gsm value. Always with % > in front of it. > > DB field and table encoding is utf-8 also. > > Try these settings and follow the thread with title > SMS from sqlbox - Problem when sending more that 160 char with greek > letters > on May 2011. > I think this will help you. > > Best Regards > Mike Nakos > > > > > > > > > > > > > > > > >
