Hi,
I don't have experience with mBlox, and I am not interested in it. The only
thing that concerns me is that Sybase requires you to make character
remapping when it shouldn't. I wouldn't worry changing the database field,
sqlbox, as well as kannel is open source, that means feel free to
experiment.
Try it, what have you got to loose? You shouldn't have to change *any* code
to get a database to store some data, the way it is meant to.
Incidentally, the characters you mentioned are in standard ASCII (7bit), so
any iso charset should support them.
BR,
Nikos
----- Original Message -----
From: "Hertanto Lie" <[email protected]>
To: "Nikos Balkanas" <[email protected]>; <[email protected]>
Sent: Thursday, July 23, 2009 4:04 AM
Subject: RE: Trouble sending $ @ _
Hi Nikos,
Thanks for the reply. We have experience with mBlox and I don't think we
needed to do anything like this.
And this is with the same setup for everything, including varchar type
for the msgdata column. How are these smsc different?
Talking about that msgdata column, doesn't this come standard from
sqlbox? I was looking at the code and I see it's creating a table with
msgdata column of type varchar(255). I'm a little worried about changing
the column type if it comes as default from sqlbox.
I did not actually make changes to kannel code so actually, there's no
branching off here. The changes that I made was in a .net application
where, in there I insert records to kannel database (just before I did
this, I replaced the symbols).
Thanks,
Hertanto
-----Original Message-----
From: Nikos Balkanas [mailto:[email protected]]
Sent: Wednesday, July 22, 2009 5:48 PM
To: Hertanto Lie; [email protected]
Subject: Re: Trouble sending $ @ _
Hi,
I am concerned that you are approaching it the wrong way. Sybase should
make
no such limitations. Can you configure these columns as binary, so that
they
accept any kind of data, irrespective of charset (instead of changing
kannel's code and branching off)?
BR,
Nikos
----- Original Message -----
From: "hlie" <[email protected]>
To: <[email protected]>
Sent: Thursday, July 23, 2009 2:02 AM
Subject: Trouble sending $ @ _
I have kannel setup + sqlbox with Sybase and I had problem sending
those
symbols to a phone.
$ will be replaced by some kind of 'o', @ will be replaced by some
kind of
'i' and _ will be replaced by some kind of double S sign.
I asked Sybase about this and they told me that the character set
supported
is the one defined in [3GPP 23.038], which means @ character must be
sent
as
0x00, $ character must be sent as 0x02.
With this info, I was able to make the $ and _ signs work by replacing
those
symbols with \x02 and \x11 respectively before inserting to send_sms
table
(Postgresql DB). But I'm having problem when I try to do the same
thing
with
\x00. \x00 is considered null, end of message or something so
everything
after \x00 will be ignored.
I'm relatively new with kannel. Does anybody know where am I doing
wrong?
Help? Thanks.
--
View this message in context:
http://www.nabble.com/Trouble-sending-%24-%40-_-tp24616463p24616463.html
Sent from the Kannel - User mailing list archive at Nabble.com.
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.392 / Virus Database: 270.13.20/2250 - Release Date:
07/22/09 05:59:00
