Re: Prototype Boolean gives external type as a VARCHAR??
Re: Prototype Boolean gives external type as a VARCHAR??
- Subject: Re: Prototype Boolean gives external type as a VARCHAR??
- From: Lachlan Deck <email@hidden>
- Date: Sat, 22 Mar 2008 17:45:53 +1100
On 22/03/2008, at 3:28 PM, Guido Neitzer wrote:
On 21.03.2008, at 21:11, Gustavo Pizano wrote:
Hello well im desingin my EOModel FINALLY!!!, and well when I set
an attribute the prototype a boolean, the External Type its set to
VARCHAR, shouldnt be BOOLEAN or BOOL or something like that?
Depends. The problem is, that databases model booleans differently
because in the SQL92 standard there was no "boolean". The varchar(5)
that writes "true" or "false" to the database is something that is
more readable than 1 and 0 and still works on all database systems.
Every database, however, handles ints or small ints just fine. So
you're external type can be smallint or tinyint and the valueType can
be 'c' to make it a Boolean.
with regards,
--
Lachlan Deck
_______________________________________________
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