Nista se nije promjenilo.
mysql> desc vesti;
+-----------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------+-------+
| id | int(11) | | | 0 | |
| datum | date | YES | | NULL | |
| naslov | tinyblob | YES | | NULL | |
| uvod | blob | YES | | NULL | |
| vest | blob | YES | | NULL | |
| thumbnail | tinyblob | YES | | NULL | |
+-----------+----------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> select hex(naslov) from vesti limit 1;
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| hex(naslov) |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| D0A0D095D097D0A3D09BD0A2D090D0A2D09820D09AD09ED09DD09AD0A3D0A0D0A1D09020323030332E20D093D09ED094D098D09DD095202D2022D09FD09BD090D09DD098D09DD09020D09820D097D094D0A0D090D092D089D09522 |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select naslov from vesti limit 1;
+---------------------------------------------------------------------------------------------+
| naslov |
+---------------------------------------------------------------------------------------------+
| Ð ÐÐУÐТÐТРÐÐÐÐУРСР2003. ÐÐÐÐÐÐ - "ÐÐÐÐÐÐÐ Ð ÐÐÐ ÐÐÐÐ" |
+---------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> alter table vesti change naslov naslov varchar(150) character set utf8 default NULL;
Query OK, 132 rows affected (0.02 sec)
Records: 132 Duplicates: 0 Warnings: 0
mysql> select hex(naslov) from vesti limit 1;
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| hex(naslov) |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| D0A0D095D097D0A3D09BD0A2D090D0A2D09820D09AD09ED09DD09AD0A3D0A0D0A1D09020323030332E20D093D09ED094D098D09DD095202D2022D09FD09BD090D09DD098D09DD09020D09820D097D094D0A0D090D092D089D09522 |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> desc vesti;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| id | int(11) | | | 0 | |
| datum | date | YES | | NULL | |
| naslov | varchar(150) | YES | | NULL | |
| uvod | blob | YES | | NULL | |
| vest | blob | YES | | NULL | |
| thumbnail | tinyblob | YES | | NULL | |
+-----------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)