Forums

The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Other Collation vs charset

  • This topic is empty.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #42467
    fooman
    Participant

    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.

    #123369
    TylerNYC
    Member

    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)
  • The forum ‘Other’ is closed to new topics and replies.