Hello my friends! How i can convert all data from mysql database to utf8 encoding? I am from Serbia, in my language there are special characters like ćžđšž... They are shown as ���� .... I tryed some scripts, ALTER TABLE and still nothing.... Please, post reply just if you are sure how to do that... Thanks my friends! All the best!
alter table whould work! example: ALTER TABLE `forum` CHANGE COLUMN `text` `text` longtext CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL;