grails配置mysql

sun201200204

把mysql的jdbc驱动放到lib目录下。
grails-app\conf\DataSource.groovy：
dataSource {//pooled = true//driverClassName = "org.hsqldb.jdbcDriver"//username = "sa"//password = ""pooled = falsedriverClassName = "com.mysql.jdbc.Driver"username = "root"password = "888888"}hibernate {    cache.use_second_level_cache=true    cache.use_query_cache=true    cache.provider_class='com.opensymphony.oscache.hibernate.OSCacheProvider'}// environment specific settingsenvironments {development {dataSource {dbCreate = "create-drop" // one of 'create', 'create-drop','update'//url = "jdbc:hsqldb:mem:devDB"url = "jdbc:mysql://localhost:3306/contact_dev?useUnicode=true&characterEncoding=UTF-8"}}test {dataSource {dbCreate = "update"//url = "jdbc:hsqldb:mem:testDb"url = "jdbc:mysql://localhost:3306/contact_test?useUnicode=true&characterEncoding=UTF-8"}}production {dataSource {dbCreate = "update"//url = "jdbc:hsqldb:file:prodDb;shutdown=true"url = "jdbc:mysql://localhost:3306/contact_prod?useUnicode=true&characterEncoding=UTF-8"}}} 
 
让Grails + MySQL正确处理中文
其实Grails用MySQL数据源处理中文还是很方便的，基本只要注意2点：

在xxxDataSource.groovy里，mysql url注意要加上参数，例如：jdbc:mysql://server?useUnicode=true&characterEncoding=UTF-8
MySQL数据库要用UTF-8编码
create database book_dev character set utf8
另外，gsp里要注意：
< meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″ />
默认应该就是这样
 
 
1 在my.cf文件的[mysqld]段设置：
default-character-set=utf8

2 单独设置某个数据库：
alter database testdb character set utf8;

3.查看mysql支持的编码：
show character set;