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: Mike Schrag <email@hidden>
- Date: Sat, 22 Mar 2008 08:48:34 -0400
ERPrototypes has an intBoolean prototype as well.
ms
On Mar 22, 2008, at 2:45 AM, Lachlan Deck wrote:
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
_______________________________________________
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