From: Damien Lespiau Date: Sun, 31 Aug 2014 00:02:37 +0000 (+0100) Subject: INSTALL: Sprinkle a few UTF-8 in the mysql documentation X-Git-Url: http://git.ozlabs.org/?p=patchwork;a=commitdiff_plain;h=e4f09a3605ea8f1efeeb6cae1fdf3bba9dbd412c INSTALL: Sprinkle a few UTF-8 in the mysql documentation When not specifying the charset/collation, I managed to create a latin1 database where all strings were encoded in latin1. That's really not ideal. Adding 'CHARACTER SET utf8' when creating the DB fixes it. Then: $ ./manage.py syncdb will correctly create tables with UTF-8 encoded rows. However, for some reason, when django creates the test tables, that default, DB wide, encoding is not respected and one needs to provide an additional TEST_CHARSET entry in the config dictionary. Signed-off-by: Damien Lespiau Signed-off-by: Jeremy Kerr --- diff --git a/docs/INSTALL b/docs/INSTALL index dad9c7e..d40ddd2 100644 --- a/docs/INSTALL +++ b/docs/INSTALL @@ -65,7 +65,7 @@ in brackets): For MySQL: $ mysql - > CREATE DATABASE 'patchwork'; + > CREATE DATABASE 'patchwork' CHARACTER SET utf8; > CREATE USER 'www-data'@'localhost' IDENTIFIED BY ''; > CREATE USER 'nobody'@'localhost' IDENTIFIED BY ''; @@ -81,9 +81,14 @@ in brackets): 'USER': 'patchwork', 'PASSWORD': 'my_secret_password', 'NAME': 'patchwork', + 'TEST_CHARSET': 'utf8', }, } + TEST_CHARSET is used when creating tables for the test suite. Without + it, tests checking for the correct handling of non-ASCII characters + fail. + 2. Django setup Set up some initial directories in the patchwork base directory: