I am experimenting to create an empty table, then use manual sql to change
the default charset and later add columns to it. this should work, but I
will let you know later.
On Thu, Apr 23, 2009 at 11:28 AM, Voxland, Nathan <
[email protected]> wrote:
> 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:[email protected]]
> *Sent:* Thursday, April 23, 2009 1:20 PM
> *To:* [email protected]
> *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
> [email protected]
>
> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>
>
--
Sven Haiges
[email protected]
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
