Re: iso-8859-2, utf-8, or how with nokia 5110

[Horvath, Akos]

Sorry for answerring so late, I've just tried.
Yes, I can. Everything is OK with the accentuated letters from the command line.
Terminal set to utf8.

But from database:

Mysql started:
==========
mysqld --character-set-server=utf8 --collation-server=utf8_unicode_ci

Database converted:
===============
mysql> alter database sms character set utf8 collate utf8_unicode_ci;
Query OK, 1 row affected (0.00 sec)

mysql> show variables like '%_database';
+------------------------+-----------------+
| Variable_name          | Value           |
+------------------------+-----------------+
| character_set_database | utf8            |
| collation_database     | utf8_unicode_ci |
| skip_show_database     | OFF             |
+------------------------+-----------------+
3 rows in set (0.00 sec)


Tables converted:
=============

mysql> ALTER TABLE inbox CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Query OK, 14 rows affected (0.05 sec)

mysql>ALTER TABLE outbox CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Query OK, 29 rows affected (0.00 sec)


Text inserted into database from terminal:
==============================

mysql> insert into outbox(number,text)
values('+36.........','Árvíztűrő tükörfúrógép');
Query OK, 1 row affected (0.00 sec)


SMSD:
=====

Message sent: 0x02 / 0x0056
00 01 00 01 02 00 07 91 63 02 39 00 90 f9 00 00 |         c 9
00 00 11 00 00 08 2c 0b 91 63 02 55 58 19 f4 00 |       ,  c UX
00 00 00 a9 00 00 00 00 00 00 00 3f 00 72 00 76 |            ? r v
00 3f 00 7a 00 74 00 3f 00 72 00 3f 00 20 00 74 |  ? z t ? r ?   t
00 3f 00 6b 00 3f 00 72 00 66 00 3f 00 72 00 3f |  ? k ? r f ? r ?
00 67 00 3f 00 70                               |  g ? p



Message displayed on phone:
======================

?rv?zt?r? t?k?rf?r?g?p


What do I do wrong?