Nu cred ca sunt singurul care a facut upgrade la wordpress si si-a furat-o rau cu diacriticile. De taguri nici sa nu vorbim. Ultimate Tag Warrior e un nesimtit si un prost crescut. :)
Cand am schimbat tema m-am trezit cu urmatoarele semne prin textele mele: ş, î, â si ţ. Verificat baza de date, ok. Verificat UTF-8 peste tot, ok. Am luat decizia sa renunt definitiv la diacritice. Nu stiu ce a fost in capul meu cand m-am apucat sa scriu cu diacritice! Am schimbat cateva posturi de mana pana mi-am dat seama de urmatoarea relatie:
ÅŸ -> s
î -> i
â -> a
Å£ -> t
Astfel am ajuns aici:
UPDATE wp_posts SET post_title = replace( post_title, ‘ă’, ‘a’ ) ;
UPDATE wp_posts SET post_title = replace( post_title, ‘ÅŸ’, ‘s’ ) ;
UPDATE wp_posts SET post_title = replace( post_title, ‘î’, ‘i’ ) ;
UPDATE wp_posts SET post_title = replace( post_title, ‘â’, ‘a’ ) ;
UPDATE wp_posts SET post_title = replace( post_title, ‘Å£’, ‘t’ ) ;
UPDATE wp_posts SET post_content = replace( post_content, ‘ă’, ‘a’ ) ;
UPDATE wp_posts SET post_content = replace( post_content, ‘ÅŸ’, ‘s’ ) ;
UPDATE wp_posts SET post_content = replace( post_content, ‘î’, ‘i’ ) ;
UPDATE wp_posts SET post_content = replace( post_content, ‘â’, ‘a’ ) ;
UPDATE wp_posts SET post_content = replace( post_content, ‘Å£’, ‘t’ ) ;
Asa ca daca ai aceeasi problema, deschide un phpmyadmin (daca nu stii ce inseamna intreaba pe cel ce iti tine hostingul) si executa comenzile de mai sus. Merg cu wordpress 2.3.3. dar nu cred ca ar face probleme in nici o distributie. Tabela si coloanele ar trebui sa fie in principiu aceleasi.
Deci am rezolvat diacriticele in 5 minte. Definitiv! Spor.
Later edit: Am mai descoperit Î -> I, Ş -> S, Ţ -> T
Later edit: si pentru tabela de comentarii.
UPDATE wp_comments SET comment_content = replace( comment_content, ‘ă’, ‘a’ ) ;
UPDATE wp_comments SET comment_content = replace( comment_content, ‘ÅŸ’, ‘s’ ) ;
UPDATE wp_comments SET comment_content = replace( comment_content, ‘î’, ‘i’ ) ;
UPDATE wp_comments SET comment_content = replace( comment_content, ‘â’, ‘a’ ) ;
UPDATE wp_comments SET comment_content = replace( comment_content, ‘Å£’, ‘t’ ) ;
UPDATE wp_comments SET comment_author = replace( comment_author, ‘ă’, ‘a’ ) ;
UPDATE wp_comments SET comment_author = replace( comment_author, ‘ÅŸ’, ‘s’ ) ;
UPDATE wp_comments SET comment_author = replace( comment_author, ‘î’, ‘i’ ) ;
UPDATE wp_comments SET comment_author = replace( comment_author, ‘â’, ‘a’ ) ;
UPDATE wp_comments SET comment_author = replace( comment_author, ‘Å£’, ‘t’ ) ;
