RE: smsd and scandinavian characters cut out problem

[Jan Derfinak]

On Tue, 9 Mar 2010, Ari A wrote:

Hello.

Sorry for delay I was very busy in the meantime.
But I must write that I'm confused with result of your test.

For example in this sequence:

==
Reading SMS 2 of 21
gn_sms_get returned error 16: The given memory location is invalid.
1. +35844xxxxxxx   2010-03-09 13:42:03+02 Scandinavian letter test ?????? ??????
==

Line above shows the message readed from phone without any interaction with
mysql. But the same code is used for file module. I don't understand why the
result is different (you wrote, that file module works right).

==
INBOX: Message before real_escape: Scandinavian letter test ?????? ??????
INBOX: Message after real_escape: Scandinavian letter test ?????? ??????
Message: Scandinavian letter test ?????? ??????
INBOX: Message selected from DB: Scandinavian letter test ?????? ??????
Everything OK
==

These lines only shows that message is saved to db in state as is it readed
from phone.

Next sequence:
==
ucs2_encode/iconv: Invalid or incomplete multibyte or wide character
Sending SMS: 044xxxxxxx, Scandinavian letter test ????????? ??????
==

Before "Sending SMS" text is printed, smsd only reads data from DB. And it
looks that sms fetched from DB is broken.

==
Inserting Event: 0
Processing Event: 0
ucs2_encode/iconv: Invalid or incomplete multibyte or wide character
Address: 044xxxxxxx
Text: Scandinavian letter test ????????? ??????
Sending to 044xxxxxxx successful.
==

And then smsd sends broken sms.
But as I mention above in receive test, data were broken before added to DB.

So I'm confused and I'm unable to imagine what happens.

Are you able to send me:
1. Output of "echo status | mysql dbname" command
2. mysqldump of your db which I can load in my mysql server


jan

--