Recent Topics

UTF-8 and Nevada

Started by on Mar 19, 2008 – Contents updated: Mar 19, 2008

Mar 19, 2008 13:48    

My b2evolution Version: Not Entered

I am using Renaissance on my blogs. Through a certain cool workaround given to me by a member I could have all my databases in UTF-8.

Now Nevada has been released, but I am afraid that it will convert my databases back to Latin 1 or something, with all those bothersome NCR's. Am I right, or maybe Nevada has full UTF-8 support now?

In case the installation of Nevada will convert all to UTF-8 again, where is the threads to turn my DB's into UTF-8 again, please?

Thanks in advance :D

Mar 19, 2008 14:00

ALTER TABLE evo_antispam DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_basedomains DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_bloggroups DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_blogs DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_blogusers DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_categories DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_coll_settings DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_comments DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_cron DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_cron__log DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_cron__task DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_files DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_filetypes DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_groups DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_hitlogevo_items DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_items__item DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_items__itemtag DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_items__prerendering DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_items__status DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_items__tag DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_items__type DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_links DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_locales DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_pluginevents DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_plugins DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_pluginsettings DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_pluginusersettings DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_plugin_starrating_19_ratings DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_postcats DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_sessions DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_settingsevo_skins DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_skins__container DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_skins__skin DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_subscriptions DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_useragents DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_users DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_usersettings DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE evo_widget DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

this will convert your tables into utf-8 but sub-tables are not included, you may add them manually thats the thing in the end

Mar 19, 2008 14:09

The installer doesn't convert charset, so you don't have to worry about it.

Mar 23, 2008 10:53

Thanks for all your help, friends. I have unpgraded my blog successfully now. No problem at all!


Form is loading...

Advanced CMS – This forum is powered by b2evolution CMS, a complete engine for your website.