I tried that using the php urlencode function but i only got the urlencoded message sent to me.
2011/5/22 Rene Kluwen <[email protected]> > Try to urlencode the message before inserting. > > > > *From:* [email protected] [mailto:[email protected]] *On > Behalf Of *Andreas Bergman > *Sent:* Sunday, 22 May, 2011 15:01 > *To:* [email protected] > *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 <[email protected]> > > 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: [email protected] > 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 > 0708-768300 > [email protected] > > > > > -- > Andreas Bergman > www.abergman.se > 0708-768300 > [email protected] > -- Andreas Bergman www.abergman.se 0708-768300 [email protected]
