Value Types for VARCHAR2 external types
Value Types for VARCHAR2 external types
- Subject: Value Types for VARCHAR2 external types
- From: Nick Pilch <email@hidden>
- Date: Tue, 26 Nov 2002 14:38:59 -0800
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.
Strangely, the value is not trimmed when being read from the database. Hmm...
--
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.