Hi Andreas,
please read sqlbox greek gsm-7 thread
sent at Fri May 13 18:41:38 CEST 2011.
In that case we wanted to send
@ΔΦΓΛ by inserting on msgdata field '%00%10%12%13%14'.
In your case, according to http://en.wikipedia.org/wiki/GSM_03.38
you must insert '%0F%7B%7C'.
Except the way to insert data to db field, read also the settings you
must have to .conf file.
Best regards
Mike Nakos
On 21:59, Andreas Bergman wrote:
I tried that using the php urlencode function but i only got the
urlencoded message sent to me.
2011/5/22 Rene Kluwen <rene.klu...@chimit.nl
<mailto:rene.klu...@chimit.nl>>
Try to urlencode the message before inserting.
*From:*users-boun...@kannel.org <mailto:users-boun...@kannel.org>
[mailto:users-boun...@kannel.org
<mailto:users-boun...@kannel.org>] *On Behalf Of *Andreas Bergman
*Sent:* Sunday, 22 May, 2011 15:01
*To:* us...@vm1.kannel.org <mailto:us...@vm1.kannel.org>
*Subject:* Re: sqlbox and åäö
I'm running the latest cvs version, with the unicode fix.
The MySQL tables are changed to utf8 and charset is set to utf8
when sending the message.
The bblog looks like this when inserting a message into send_sms
with msgdata 'åäö'
2011-05-22 15:00:01 [12051] [13] DEBUG: boxc_receiver: sms received
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput
(0.00,0.00)
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Manually
forced source addr ton = 5, source add npi = 1
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Manually
forced dest addr ton = 1, dest add npi = 1
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Sending PDU:
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU 0x1d108f90 dump:
2011-05-22 15:00:01 [12051] [6] DEBUG: type_name: submit_sm
2011-05-22 15:00:01 [12051] [6] DEBUG: command_id: 4 = 0x00000004
2011-05-22 15:00:01 [12051] [6] DEBUG: command_status: 0 =
0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG: sequence_number: 8 =
0x00000008
2011-05-22 15:00:01 [12051] [6] DEBUG: service_type: NULL
2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr_ton: 5 =
0x00000005
2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr_npi: 0 =
0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG: source_addr: "abergman"
2011-05-22 15:00:01 [12051] [6] DEBUG: dest_addr_ton: 1 = 0x00000001
2011-05-22 15:00:01 [12051] [6] DEBUG: dest_addr_npi: 1 = 0x00000001
2011-05-22 15:00:01 [12051] [6] DEBUG: destination_addr:
"46708768300"
2011-05-22 15:00:01 [12051] [6] DEBUG: esm_class: 3 = 0x00000003
2011-05-22 15:00:01 [12051] [6] DEBUG: protocol_id: 0 = 0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG: priority_flag: 0 = 0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG: schedule_delivery_time: NULL
2011-05-22 15:00:01 [12051] [6] DEBUG: validity_period: NULL
2011-05-22 15:00:01 [12051] [6] DEBUG: registered_delivery: 0 =
0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG: replace_if_present_flag:
0 = 0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG: data_coding: 0 = 0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG: sm_default_msg_id: 0 =
0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG: sm_length: 1 = 0x00000001
2011-05-22 15:00:01 [12051] [6] DEBUG: short_message: "?"
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU dump ends.
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput
(1.00,0.00)
2011-05-22 15:00:01 [12051] [13] DEBUG: send_msg: sending msg to
boxc: <sqlbox>
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput
(1.00,0.00)
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: Got PDU:
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU 0x1d10a0f0 dump:
2011-05-22 15:00:01 [12051] [6] DEBUG: type_name: submit_sm_resp
2011-05-22 15:00:01 [12051] [6] DEBUG: command_id: 2147483652 =
0x80000004
2011-05-22 15:00:01 [12051] [6] DEBUG: command_status: 0 =
0x00000000
2011-05-22 15:00:01 [12051] [6] DEBUG: sequence_number: 8 =
0x00000008
2011-05-22 15:00:01 [12051] [6] DEBUG: message_id:
"637581306069203840"
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP PDU dump ends.
2011-05-22 15:00:01 [12051] [6] DEBUG: SMPP[beepsend]: throughput
(1.00,0.00)
Seems like the sqlbox isn't insering the åäö into bearerbox correctly?
/A
2011/5/22 Nikos Balkanas <nbalka...@gmail.com
<mailto:nbalka...@gmail.com>>
Hi,
there was a long discussion about it in the list for the past 2
weeks. I believe Renee mentioned that sqlbox was patched. Please
download latest sqlbox and retry.
BR,
Nikos
----- Original Message ----- From: Andreas Bergman
To: users@kannel.org <mailto:users@kannel.org>
Sent: Sunday, May 22, 2011 1:36 PM
Subject: sqlbox and εδφ
Hi!
When sending εδφ in messages thrugh sqlbox they are changed to ??
i assume this has something to do with unicode chars?
The system is en_EN.UTF-8 and in the database it looks correct, is
Stipes unicodepatch the solution or?
Br
Andreas
--
Andreas Bergman
www.abergman.se <http://www.abergman.se>
0708-768300
andr...@abergman.se <mailto:andr...@abergman.se>
--
Andreas Bergman
www.abergman.se <http://www.abergman.se>
0708-768300
andr...@abergman.se <mailto:andr...@abergman.se>
--
Andreas Bergman
www.abergman.se <http://www.abergman.se>
0708-768300
andr...@abergman.se <mailto:andr...@abergman.se>
