Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Problems with norwegian characters æøå
sp_NewPost Add Reply sp_NewTopic Add Topic
November 19, 2014
5:07 pm
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

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:
"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=;charset=UTF8;Database=db;User=sms;Password=*****;Option=3;

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

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502