Re: postgresql and 'text' prototype
Re: postgresql and 'text' prototype
- Subject: Re: postgresql and 'text' prototype
- From: Helmut Schottmüller <email@hidden>
- Date: Tue, 01 Jul 2008 17:22:54 +0200
Using a StringColumn is not working.
You should use table.newColumn("c_firstname",
java.sql.Types.LONGVARCHAR, 0, 0, 0, false, "");
This works for me.
But why are you using TEXT types for small text fields like firstname.
Correct me if I'm wrong but I assume that you have much more
performance and indexing power if you use varchar instead.
Regards,
Helmut
Am 01.07.2008 um 15:43 schrieb email@hidden:
I have been experimenting with the prototyping functions and
migrations. I generally do not use varchar instead just using the
data type 'text'. this seems to work using the longText prototype
selection (it gives a Data Type as: String (RTRIM) - String C).
However, if I try to Generate Migration, I get:
peopleTable.newStringColumn("c_firstname", ${attribute.width}, false);
as there is no 'width' for a column of type 'text', I was wonder if
I am doing something wrong. Is there a column type to use to create
a column of type 'text' while using migrations?
Ted
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden