Inserting an empty string in a column

[DavidRobison]

I am trying to write a change set to insert data. One piece of the data
is an empty string. When I use the definition:

<column name="f_table_catalog" value=""/>

The generated SQL tries to insert a null rather than an empty string.
ANy thoughts?
David

--

David R Robison
Open Roads Consulting, Inc.
103 Watson Road, Chesapeake, VA 23320
phone: [phone]
e-mail: drrobison@...
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/book_detail.php?id=2579

 



------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[LiquiBase Community Forum]

Sorry for the slow response.  We have struggled a bit with the best
way to represent inserting null vs empty string.   I think if you are
wanting to insert an empty string you will need to use the <sql> tag
at this point.

Nathan

On Tue, Nov 3, 2009 at 11:01 AM, David R Robison
<drrobison@...> wrote:

> I am trying to write a change set to insert data. One piece of the data
> is an empty string. When I use the definition:
>
> <column name="f_table_catalog" value=""/>
>
> The generated SQL tries to insert a null rather than an empty string.
> ANy thoughts?
> David
>
> --
>
> David R Robison
> Open Roads Consulting, Inc.
> 103 Watson Road, Chesapeake, VA 23320
> phone: [phone]
> e-mail: drrobison@...
> web: http://openroadsconsulting.com
> blog: http://therobe.blogspot.com
> book: http://www.xulonpress.com/book_detail.php?id=2579
>
>
>
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Liquibase-user mailing list
> Liquibase-user@...
> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user