changing your default char set from latin1_swedish_ci to utf8_unicode_ci

I found many takes with the wrong collation . A lot of sites found in google were NOT helful.
myphpadmin was the most helpful . you have to run an sql query for each table

or you can try to run it for the whole database

ALTER DATABASE `foo` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; (this did not work for me)

what worked was

ALTER TABLE `wp_bb_meta` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

ok just doing that much DID NOT fix the problem . you need to open each table and look at each field

for non buddy press installs
ALTER TABLE `wp_commentmeta` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE `wp_comments` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE `wp_links` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE `wp_options` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE `wp_postmeta` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE `wp_posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE `wp_term_relationships` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE `wp_term_taxonomy` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE `wp_terms` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE `wp_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

ALTER TABLE `wp_posts` CHANGE `post_content` `post_content` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
ALTER TABLE `wp_posts` CHANGE `post_title` `post_title` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
ALTER TABLE `wp_posts` CHANGE `post_excerpt` `post_excerpt` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
ALTER TABLE `wp_posts` CHANGE `comment_status` `comment_status` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘open’
ALTER TABLE `wp_posts` CHANGE `ping_status` `ping_status` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘open’
ALTER TABLE `wp_posts` CHANGE `post_password` `post_password` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ”
ALTER TABLE `wp_posts` CHANGE `post_name` `post_name` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ”
ALTER TABLE `wp_posts` CHANGE `to_ping` `to_ping` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
ALTER TABLE `wp_posts` CHANGE `pinged` `pinged` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
ALTER TABLE `wp_posts` CHANGE `post_content_filtered` `post_content_filtered` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
ALTER TABLE `wp_posts` CHANGE `guid` `guid` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ”
ALTER TABLE `wp_posts` CHANGE `post_type` `post_type` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘post’
ALTER TABLE `wp_posts` CHANGE `post_mime_type` `post_mime_type` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ”

ALTER TABLE `wp_postmeta` CHANGE `meta_key` `meta_key` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL
ALTER TABLE `wp_postmeta` CHANGE `meta_value` `meta_value` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL

ALTER TABLE `wp_options` CHANGE `option_name` `option_name` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ”
ALTER TABLE `wp_options` CHANGE `option_value` `option_value` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
ALTER TABLE `wp_options` CHANGE `autoload` `autoload` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘yes’

ALTER TABLE `wp_commentmeta` CHANGE `meta_key` `meta_key` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL
ALTER TABLE `wp_commentmeta` CHANGE `meta_value` `meta_value` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL