Forums

Give help. Get help.

  • # February 4, 2013 at 11:54 am

    When speaking of a MySQL db, are Collation and Charset the same?

    I’ve seen a post on stackoverflow that states: ‘The column that you describe is text utf8_unicode_ci. utf8_unicode_ci is the collation, make sure the charset on that column is set to utf8.’

    I more-often-than-not use a collation of ‘utf8_general_ci’.

    That just made me wonder if the two terms are interchangeable when it comes to MySQL databases.

    This entire thing is coming up for a reason, [HTMLPurifier](http://htmlpurifier.org/ “HTMLPurifier”) converting the nbsp; character as Â. Not sure why but upon conversion that lead to a giant can of worms.

    # February 4, 2013 at 9:51 pm

    http://www.informit.com/articles/article.aspx?p=328641

    That’s a good article explaining it.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

icon-anchoricon-closeicon-emailicon-linkicon-logo-staricon-menuicon-nav-guideicon-searchicon-staricon-tag