Re: Value Types for VARCHAR2 external types
Re: Value Types for VARCHAR2 external types
- Subject: Re: Value Types for VARCHAR2 external types
- From: Art Isbell <email@hidden>
- Date: Tue, 26 Nov 2002 14:02:22 -1000
On Tuesday, November 26, 2002, at 12:38 PM, Nick Pilch wrote:
I'm a bit confused by the documentation versus what I'm seeing in
practice. I have an attribute whose external type is VARCHAR2. It has
no Value Type set. I'm seeing that values are getting trimmed before
being written to the database. In particular, I want to write a single
space out to a column, but WO translates it into a null string when
generating the SQL (a check of the value right before saving confirms
that valueForKey correctly returns " ".
It seems like a case of trimming. The documentation states that
"Attributes that map to varchar columns are never trimmed, regardless
of value type." So is VARCHAR2 not a varchar column? To try to force
no trimming, which Value Type is best? The documentation is a little
hard to understand on what the string Value Types do.
Have you saved a string with trailing space characters? If so, were
these trailing space characters trimmed? What I'm wondering is whether
WO is considering a value that's nothing but one or more space
characters null or whether it's actually trimming trailing space
characters.
Or could it be the browser that's not passing the space character to
the WO app server? Have you checked the value of the variable bound to
the text field in which your value was input? If so, does it contain
the space character?
Art
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.