It is not currently, ou'll have to specify your createTable statement
using <sql> as well.
Can you set utf8 as the default in your database config?
Nathan
From: Sven Haiges [mailto:sven.hai...@googlemail.com]
Sent: Thursday, April 23, 2009 1:20 PM
To: liquibase-user@lists.sourceforge.net
Subject: [Liquibase-user] Specify default charset fro creates
Hi all,
I got some issue with being unable to specify the charset with the
CREATE table statement. We use liquibase to generate the SQL so we see
the
CREATE TABLE ()
DEFAULT CHARSET=utf8;
is missing. To resolve this, I first used soem manuel SQL like this (for
MySQL):
<sql>ALTER TABLE `MacSmsJournal` CHARACTER SET utf8;</sql>
The issue with this is that the columns the CREATE created are still
usin gthe default charset as the change to the default charset is coming
after the create.
Is it possible to specify the default charset for the CREATE statement
in Liquibase?
Thanx
Sven
--
Sven Haiges
sven.hai...@googlemail.com
Yahoo Messenger / Skype: hansamann
Personal Homepage, Wiki & Blog: http://www.svenhaiges.de
Subscribe to the Grails Podcast:
http://feeds.grailspodcast.com/grailspodcast
http://www.grailspodcast.com
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Liquibase-user mailing list
Liquibase-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/liquibase-user
