Support forum

Home Support forum Using Diafaan SMS Server Problems with norwegian characters …

Problems with norwegian characters æøå

Add Reply

Add Topic

November 19, 2014
5:07 pm

Henk Helmantel

Admin

Forum Posts: 1488

Member Since:
May 28, 2013

Offline

Quote

Hello Robert,

Thank you for the clear description of the problem, that makes it a lot easier to find a solution.

The mangled characters are most likely caused by a Unicode issue between the MySQL database and the ODBC driver. The reason for this is probably that you are using the ANSI version of the ODBC driver instead of the UNICODE version. If that is indeed the source of the problem, the solution is to replace '{MySQL ODBC 5.3 ANSI Driver}' in the connection string in Diafaan SMS Server with '{MySQL ODBC 5.3 UNICODE Driver}'.

If that does not solves the problem, there might be some other issue between the specific versions of the MySQL database and the ODBC driver. Sometimes using a different (older) version of the ODBC driver helps.

Regards, Henk

November 19, 2014
4:08 pm

Robert A

Guest

Guests

Quote

I have a PHP script that inserts a textmessage to my database, table: sms_outbox. The table structure is the same as the example in the manual. Do I need to encode the message before inserting it to the database to get the norwegian characters to work?

When I insert this message "Hei på deg! æøå ÆØÅ #%&"
I get this textmessage on my phone: "Hei pÃ¥ deg! Ã¦Ã¸Ã¥ Ã†Ã˜Ã… #%&"

Here is a DB export of sms_outbox:
INSERT INTO `sms_outbox` (`Id`, `MessageTo`, `MessageFrom`, `MessageText`, `MessageType`, `Gateway`, `UserId`, `UserInfo`, `Priority`, `Scheduled`, `IsSent`, `IsRead`) VALUES
(7, '12345678', '12345678', 'Hei på deg! æøå ÆØÅ #%&', 'sms.text', NULL, NULL, NULL, NULL, NULL, 0, -1),

(Table charset: DEFAULT CHARSET=utf8)

Her is export from SQL connector in Diafaan:
"SendTime","Status","To","Message","From","MessageType","MessageParts","PDU","UserId","UserInfo","ReceiveTime","GatewayId","GatewayName","GatewayList","ConnectorId","MessageId","StatusCode","StatusText","ErrorCode","ErrorText","ResultTrace","Accounting","Receipt","SendTLVList","ReceiptTLVList"
"19.11.2014 16:00:13","Sent","12345678","Hei pÃ¥ deg! Ã¦Ã¸Ã¥ Ã†Ã˜Ã… #%&","12345678","sms.automatic","1","0691742900010031100891992367630008AA3C0048006500690020007000C300A500200064006500670021002000C300A600C300B800C300A5002000C3202000C302DC00C320260020002300250026","","","31.12.9999 23:59:59","1","Netcom (Robert - test)","","2","1:12345678:87","200","Success: Message accepted by GSM modem gateway.","","","*1*:200","","","",""

My ODBC string:
Driver={MySQL ODBC 5.3 ANSI Driver};Server=172.27.1.85;charset=UTF8;Database=db;User=sms;Password=*****;Option=3;

Can anyone help me get this working before my trial license expires? :-)

Add Reply

Add Topic

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)