Tinyportal UTF-8 Solution

[guvenck]

For those who are experiencing problems after installing TP (0.95b) on a working UTF-8 SMF (1.1RC3) installation, this SQL query (in an phpmyadmin window) will solve your problems.

ALTER TABLE smf_tp_articles CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE smf_tp_blocks CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE smf_tp_dlmanager CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE smf_tp_settings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE smf_tp_variables CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

You'll have to manually edit the block names or other TP content by hand afterwards.

You'll need to save your language files in UTF-8 and rename them to TP***yourlanguage-utf8.php and upload them to Themes/default/languages directory as well.


If you already have BIG problems with SMF1.1RC3 UTF-8, pay attention that you SAVE the sqldump with a text editor that can export in UTF-8 format (good old Windows Notepad does that).

[MaZz]

thanks brother. works and with TinyPortal v0.9.6beta

[guvenck]

Thanks, thought it might help someone. Cost me days and nights to successfully move my existing installation to server with a never MySQL version.