Polskie forum wsparcia dla phpBB


http://www.phpbb.pl/forum/

Problem z polskimi znakami po konwersji z phpbb2 do phpbb3

http://www.phpbb.pl/forum/viewtopic.php?f=91&t=11721

Strona 1 z 1

Problem z polskimi znakami po konwersji z phpbb2 do phpbb3

: 02 marca 2010, 10:00
autor: sylwekb
Witam wszystkich

Po konwersji z phpbb2 do phpbb3 pojawiły się zamiast polskich znaków krzaczki, problem ten występuje zarówno w tytułach jak i treści postów np:

łączmy

chciałbym nadmienić że baza phpbb2 była kodowana w utf-8 i phpbb3 także po zainstalowaniu jest utf-8
jak można to poprawić?

Konwersja przebiegła prawidłowo tzn nie pojawił się żaden błąd.

Jak mogę poprawić te krzaczki aby polskie litery wyświetlały się prawidłowo?

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpbb3

: 02 marca 2010, 20:42
autor: Widmo
Spróbuj użyć tego zapytania SQL:

Kod: Zaznacz cały

UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '³', 'ł');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'Ăł', 'ó');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'ê', 'ę');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¶', 'ś');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '±', 'ą');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'æ', 'ć');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'ñ', 'ń');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¿', 'Ż');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¼', 'ź');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '³', 'Ł');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¶', 'Ś');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'æ', 'Ć');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'ê', 'Ę');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'Ó', 'Ó');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¿', 'ż');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¼', 'Ź');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'ñ', 'Ń');


UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '³', 'ł');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'Ăł', 'ó');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'ê', 'ę');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¶', 'ś');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '±', 'ą');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'æ', 'ć');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'ñ', 'ń');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¿', 'Ż');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¼', 'ź');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '³', 'Ł');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¶', 'Ś');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'æ', 'Ć');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'ê', 'Ę');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'Ó', 'Ó');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¿', 'ż');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¼', 'Ź');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'ñ', 'Ń');


UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '³', 'ł');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'Ăł', 'ó');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ê', 'ę');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¶', 'ś');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'ą');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'æ', 'ć');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ñ', 'ń');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¿', 'Ż');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¼', 'ź');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '³', 'Ł');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¶', 'Ś');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'æ', 'Ć');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ê', 'Ę');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'Ó', 'Ó');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¿', 'ż');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¼', 'Ź');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ñ', 'Ń');


UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '³', 'ł');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'Ăł', 'ó');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'ê', 'ę');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¶', 'ś');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '±', 'ą');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'æ', 'ć');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'ñ', 'ń');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¿', 'Ż');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¼', 'ź');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '³', 'Ł');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¶', 'Ś');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'æ', 'Ć');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'ê', 'Ę');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'Ó', 'Ó');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¿', 'ż');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¼', 'Ź');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'ñ', 'Ń');


UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '³', 'ł');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'Ăł', 'ó');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'ê', 'ę');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¶', 'ś');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '±', 'ą');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'æ', 'ć');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'ñ', 'ń');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¿', 'Ż');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¼', 'ź');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '³', 'Ł');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¶', 'Ś');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'æ', 'Ć');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'ê', 'Ę');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'Ó', 'Ó');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¿', 'ż');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¼', 'Ź');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '±', 'Ą');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '±', 'Ą');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'ñ', 'Ń');


UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '³', 'ł');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'Ăł', 'ó');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'ê', 'ę');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¶', 'ś');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '±', 'ą');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'æ', 'ć');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'ñ', 'ń');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¿', 'Ż');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¼', 'ź');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '³', 'Ł');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¶', 'Ś');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'æ', 'Ć');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'ê', 'Ę');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'Ó', 'Ó');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¿', 'ż');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¼', 'Ź');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '±', 'Ą');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '±', 'Ą');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'ñ', 'Ń');


UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, '³', 'ł');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, 'ăl̷', 'ó');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, '±', 'ą');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, '¶', 'ś');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, 'ê', 'ę');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, 'ñ', 'ń');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, '¿', 'ż');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, '¼', 'ź');

UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '³', 'ł');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'Ăł', 'ó');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'ê', 'ę');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¶', 'ś');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '±', 'ą');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'æ', 'ć');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'ñ', 'ń');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¿', 'Ż');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¼', 'ź');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '³', 'Ł');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¶', 'Ś');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'æ', 'Ć');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'ê', 'Ę');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'Ó', 'Ó');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¿', 'ż');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¼', 'Ź');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '±', 'Ą');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '±', 'Ą');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'ñ', 'Ń');

UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '³', 'ł');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'Ăł', 'ó');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'ê', 'ę');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¶', 'ś');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '±', 'ą');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'æ', 'ć');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'ñ', 'ń');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¿', 'Ż');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¼', 'ź');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '³', 'Ł');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¶', 'Ś');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'æ', 'Ć');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'ê', 'Ę');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'Ó', 'Ó');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¿', 'ż');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¼', 'Ź');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '±', 'Ą');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '±', 'Ą');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'ñ', 'Ń');

UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '³', 'ł');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'Ăł', 'ó');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'ê', 'ę');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¶', 'ś');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '±', 'ą');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'æ', 'ć');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'ñ', 'ń');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¿', 'Ż');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¼', 'ź');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '³', 'Ł');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¶', 'Ś');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'æ', 'Ć');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'ê', 'Ę');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'Ó', 'Ó');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¿', 'ż');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¼', 'Ź');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '±', 'Ą');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '±', 'Ą');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'ñ', 'Ń');

UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '³', 'ł');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'Ăł', 'ó');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'ê', 'ę');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¶', 'ś');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '±', 'ą');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'æ', 'ć');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'ñ', 'ń');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¿', 'Ż');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¼', 'ź');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '³', 'Ł');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¶', 'Ś');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'æ', 'Ć');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'ê', 'Ę');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'Ó', 'Ó');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¿', 'ż');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¼', 'Ź');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '±', 'Ą');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '±', 'Ą');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'ñ', 'Ń');

UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '³', 'ł');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'Ăł', 'ó');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'ê', 'ę');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¶', 'ś');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '±', 'ą');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'æ', 'ć');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'ñ', 'ń');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¿', 'Ż');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¼', 'ź');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '³', 'Ł');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¶', 'Ś');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'æ', 'Ć');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'ê', 'Ę');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'Ó', 'Ó');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¿', 'ż');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¼', 'Ź');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '±', 'Ą');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '±', 'Ą');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'ñ', 'Ń');


UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '±', 'Ą');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'Âł', 'ł');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'Ăł', 'ó');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'ê', 'ę');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¶', 'ś');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '±', 'ą');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'æ', 'ć');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'ñ', 'ń');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¿', 'Ż');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¼', 'ź');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '³', 'Ł');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¶', 'Ś');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'æ', 'Ć');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'ê', 'Ę');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'Ó', 'Ó');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¿', 'ż');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¼', 'Ź');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¼', 'Ź');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'ñ', 'Ń');


UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '³', 'ł');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'Ăł', 'ó');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ê', 'ę');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¶', 'ś');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'ą');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'æ', 'ć');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ñ', 'ń');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¿', 'Ż');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¼', 'ź');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '³', 'Ł');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¶', 'Ś');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'æ', 'Ć');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ê', 'Ę');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'Ó', 'Ó');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¿', 'ż');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¼', 'Ź');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ñ', 'Ń');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'Ą');

UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '³', 'ł');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'Ăł', 'ó');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'ê', 'ę');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¶', 'ś');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '±', 'ą');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'æ', 'ć');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'ñ', 'ń');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¿', 'Ż');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¼', 'ź');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '³', 'Ł');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¶', 'Ś');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'æ', 'Ć');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'ê', 'Ę');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'Ó', 'Ó');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¿', 'ż');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¼', 'Ź');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '±', 'Ą');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'ñ', 'Ń');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '±', 'Ą');

UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '³', 'ł');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'Ăł', 'ó');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'ê', 'ę');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¶', 'ś');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '±', 'ą');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'æ', 'ć');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'ñ', 'ń');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¿', 'Ż');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¼', 'ź');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '³', 'Ł');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¶', 'Ś');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'æ', 'Ć');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'ê', 'Ę');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'Ó', 'Ó');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¿', 'ż');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¼', 'Ź');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '±', 'Ą');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '±', 'Ą');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'ñ', 'Ń');
Jeśli nie będzie działać to sam edytuj zapytanie:

Kod: Zaznacz cały

UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'krzaczek', 'odpowiadająca_mu_polska_litera');
I tak z każdą literą. Pamiętaj, ze duże i małe również trzeba osobno wpisywać, bo mają one inne krzaczki.

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpbb3

: 02 marca 2010, 23:46
autor: sylwekb
Wielkie dzięki wszystko działa, oczywiście z moim prefiksem i trochę innymi krzaczkami, bo te krzaczki są z iso a moje z utf-a

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

: 14 maja 2010, 23:28
autor: neverdie
Witam,

Mam podobny problem. Niestety nie mogę w ten sposób naprawić znaków, ponieważ w moim przypadku np. ą odpowiada za ń, ą i ę... W jaki sposób mogę przywrócić poprawne znaki?

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

: 15 maja 2010, 09:00
autor: Widmo
Przeczytaj jeszcze raz, ze zrozumieniem mój powyższy post i ułóż sobie zapytanie.

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

: 15 maja 2010, 10:49
autor: neverdie
Nie bardzo rozumiem? Z tego co widzę, w tamtym przypadku każdemu krzakowi odpowiadał dokładnie jeden znak polski. U mnie, czytając zakrzaczone posty, doszedłem do wniosku, że znak Ă przybiera postać zarówno Ą Ę jak i Ń. Naprawić mogę tylko kilka liter, które zakrzaczyły się np. do postaci Ăł.

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

: 15 maja 2010, 15:10
autor: jaroslw
Zapewne bazę z phpBB2 masz w kodowaniu innym niż UTF–8. Wyeksportuj ją, zmień kodowanie w pliku SQL na UTF–8 bez BOM i wgraj ją ponownie, ale do bazy również o kodowaniu Unicode. Dalej powinno być już dobrze.

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

: 15 maja 2010, 15:50
autor: neverdie
Problem w tym, że to już zrobiłem. Po przeniesieniu forum na nowy serwer, wystąpiły problemy z kodowaniem. Przerobiłem cała bazę na UTF8 (utf8_general_ci) i forum działało poprawnie. Niestety, po konwersji pojawia się ten problem.

Myślicie, że zrobienie konwersji offline może coś pomóc?

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

: 16 maja 2010, 10:36
autor: jaroslw
Możesz spróbować. Praca z bazami danych to dość delikatna sprawa. Utwórz bazę o kodowaniu utf8_unicode_ci i zobacz co z tego wyjdzie :) Możesz też podać szczegóły na temat kodowań tabel przed i po konwersji.

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

: 20 maja 2010, 16:03
autor: neverdie
Problem rozwiązałem. Najskuteczniejszym sposobem było zmienienie wszystkich polskich znaków w bazie przed konwersją na encje ;)
Strefa czasowa UTC+01:00
Strona 1 z 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/