The (re)created database by site-install is not created with the default character set utf8, even though Drupal works in UTF-8 all along.
I believe the following should be sufficient.

CREATE DATABASE `dbname` /*!40100 DEFAULT CHARACTER SET utf8 */;

Comments

moshe weitzman’s picture

moshe weitzman commented

seems like a good idea to me. what about postgres and sqlite?

maherg’s picture

maherg commented

For Postgres (haven't tried it though):

CREATE DATABASE dbname ENCODING 'UTF8';

As for sqlite, I suppose it works in UTF-8 by default ( according to this ).

moshe weitzman’s picture

moshe weitzman commented
Status: Active » Fixed

site-install now uses drush_sql_build_createdb_sql() which features UTF8 string and optional db_name quoting.

greg.1.anderson’s picture

greg.1.anderson commented

There was a typo in the pgsql code.

http://drupal.org/cvs?commit=467532

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.