Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. UTF-8 and Nevada

UTF-8 and Nevada

1 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

Back to top

2 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

Back to top

3 Mar 19, 2008 14:09

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

Back to top

4 Mar 23, 2008 10:53

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

Back to top


Form is loading...