Re: Value Types for VARCHAR2 external types
Re: Value Types for VARCHAR2 external types
- Subject: Re: Value Types for VARCHAR2 external types
- From: Nick Pilch <email@hidden>
- Date: Tue, 26 Nov 2002 16:37:24 -0800
Thanks for your comments.
I haven't tried a string with a trailing space. This might help track
down the bug -- it does kind of look like a WO bug.
The browser doesn't figure into it. I'm getting these results from a
Java Client app and I am doing printlns to verify what I put in and
what I get back. Perhaps it's an adaptor issue.
This is new behavior with 5.1.3/5.1.4. I don't get this with 4.51.
At 2:02 PM -1000 11/26/02, Art Isbell wrote:
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.
--
Nick Pilch / email@hidden
_______________________________________________
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.