"Hello all, I have a website with joomla that was originally on a MySql DB with collation Swedish, but now more eastern language is needed including arabic, and If I change the collation it doesn't work, so how to make all collation converted to UTF8? "
ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;. Or if you're still on MySQL 5.5.2 or older which didn't support 4-byte UTF-8, use utf8 instead of utf8mb4 :
Looking for free traffic for your website? Linkreferral provides free advertising for web sites, blogs, personal pages and affiliate links. Our services provide several different online marketing strategies including network, social and search traffic. It's no risk, take a minute to signup and start receiving web traffic immediately. Advertise for free now.