• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Prototype Boolean gives external type as a VARCHAR??
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


  • Follow-Ups:
    • Re: Prototype Boolean gives external type as a VARCHAR??
      • From: Guido Neitzer <email@hidden>
    • Re: Prototype Boolean gives external type as a VARCHAR??
      • From: Mike Schrag <email@hidden>
References: 
 >Prototype Boolean gives external type as a VARCHAR?? (From: Gustavo Pizano <email@hidden>)
 >Re: Prototype Boolean gives external type as a VARCHAR?? (From: Guido Neitzer <email@hidden>)

  • Prev by Date: Re: db Model and EOModel
  • Next by Date: Re: WOLips Outline
  • Previous by thread: Re: Prototype Boolean gives external type as a VARCHAR??
  • Next by thread: Re: Prototype Boolean gives external type as a VARCHAR??
  • Index(es):
    • Date
    • Thread