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]
