mysql create utf8 database

Hans-Henry Jakobsen27. January 20082. October 20086
Database, MySQL, utf8

This is the way to create a mysql database with UTF8 characterset

CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

bixit

Curious IT geek and dad.

Varuna Singh 1. September 2013 Reply

Its the simple small things, like this that make my life easier. Thanks for the quick and easy to use article and command line that I searched for :D
Sergij 23. October 2013 Reply

nice meet that info so quickly. Thanks advanced!
Fredskov 29. October 2013 Reply

You deserve more likes! Been looking for it everywhere without luck, major places as W3(crap)school and tried phpMyAdmins own SQL-field to try and see if I could find the command with no luck whatsoever.
Alexander Lang 4. April 2015 Reply

Thanks alot!
Nick Benson 13. May 2015 Reply

You’re a gentleman and a scholar; thank you!
Adrian 20. July 2015 Reply

Man, you’re the real mvp.