free advertising, online marketing, web site promotion, website traffic    What is LinkReferral?  |  My Account  |  Contact Us  |  Marketing Tips  |  FAQs     

Forums > website development > databasespost a new reply

Linkreferral Forums - Change MySQL collation to UTF8
Post By: Post Date:   2010-09-10 21:42:22
member since:
member profile

(0 reviews)

add to favorites
review this site

topics started:
replies posted:

Change MySQL collation to UTF8

"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? "
Post By: member_438725Post Date:   2018-02-13 06:32:05
name: Eddy
member since: 2017-11-08
member profile
health / products
(21 reviews)

add to favorites
review this site

topics started: 0
replies posted: 38
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 :


post a new reply0 - 1 of 1 replies    << prev  |  next >>

Free website marketing, free traffic

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.

©2019 All Rights Reserved..   Terms Of Use