Skip to content

WebPlay – And let's play

Tutorials, How to and knowledge base

  • Home
  • About
  • Operating Systems
    • Linux
      • Centos
        • Centos 6.3
      • Ubuntu
      • Linux Mint
        • Fortune Cookies
    • Solaris
    • Windows Server
      • Windows Server 2012
    • FreeBSD
    • Macintosh
  • Blog
  • Digital Ocean promo code
  • pet projects
  • cryptocurrency

Tag: CHARACTER SET

Posted on August 21, 2012

MySQL – Create database with collation and Character set utf8

If you want to create a database in MySQL with default charset and collate utf8, then you simply have to give the following command:

 

CREATE DATABASE "database_name"
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;

 

Recent Posts

  • Explaining Bitcoin
  • How to enable core dumps in RHEL 7
  • How to change the default SSH port
  • The Zen of Python by Tim Peters
  • My new raspberry pi 2 – Choosing the SD card

Categories

  • Bind
  • Blog
  • Centos
  • Centos 6.3
  • CentOS 6.4
  • Centos 7
  • Cloud
  • CMS
  • cryptocurrency
  • Digitalocean
  • Fortune Cookies
  • FreeBSD
  • GroupWare
  • Horde
  • IDE's
  • Kolab
  • Linux
  • Linux Mint
  • Macintosh
  • Mailing List
  • MySQL
  • nVidia Cuda
  • pet projects
  • PHP
  • plugins
  • postfix
  • Programming
  • roundcube
  • Security
  • Solaris
  • Ubuntu
  • Web Development
  • webhosting
  • webmail
  • Windows Server
  • Windows Server 2012
  • Wordpress
  • Zend Framework

Donation

In case you want to thank me for my help and support my work, please buy me a beer!

Cheers!

 

Proudly powered by WordPress