play framework mysql統一utf8

標籤：

表單提交中文欄位，使用預設設定，亂碼。

全部統一為utf8。伺服器為centos，只做示範，沒考慮其他平台瀏覽器編碼。

1.將mysql相關配置全改為utf8。 vim /etc/my.cnf

[mysqld]datadir=/var/lib/mysql#datadir=/home/mysqlsocket=/var/lib/mysql/mysql.sock#socket=/home/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]#log-error=/var/log/mysqld.loglog-error=/var/log/mysqld.log#pid-file=/var/run/mysqld/mysqld.pidpid-file=/var/run/mysqld/mysqld.pid#add by userdefault-character-set=utf8[mysqld]init_connect=’SET NAMES utf8’default-character-set=utf8[mysql]default-character-set=utf8

2.建立資料庫 utf8

REATE DATABASE `databasename` CHARACTER SET ‘utf8‘ COLLATE ‘utf8_general_ci‘;

3.建立表也utf8

CREATE TABLE IF NOT EXISTS suploadfileinfo (id INT auto_increment primary key not null,filename VARCHAR(255),filesize    VARCHAR(255),time TIMESTAMP DEFAULT now())ENGINE=InnoDB   DEFAULT   CHARSET=utf8;

4. play framework串連mysql時也utf8. conf/application.conf

db.default.driver= com.mysql.jdbc.Driverdb.default.url="jdbc:mysql://localhost/machinelearning?useUnicode=true&characterEncoding=UTF-8"db.default.username=rootdb.default.password=""

play framework mysql統一utf8