Re: Type BOOLEAN

Kevin Rosenberg <kevin-HJRc7zDS/[email protected]>
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]> 
Edi Weitz wrote:
> How about having a user-specified slot-type GENERALIZED-BOOLEAN which
> translates to the CL type T but is stored as
>   (if val "t" "f")
> in the database?

Sure, that's fine. Would you want it to follow individual backend
semantics for BOOLEAN? For example, mysql considers BOOLEAN to be
synonym for TINYINT. Also, ODBC doesn't have a BOOLEAN type and
various ODBC drivers handle boolean differently.

CLSQL has a fair bit of code so that a OO :type boolean slot has the
same semantics as a native SQL BOOLEAN column. Do you need such
compatibility with GENERALIZED-BOOLEAN or just a CHAR(1) column with
't' or 'f' stored?

Kevin



-- 
Kevin Rosenberg
kevin-HJRc7zDS/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.