<< Can you insert then 'T' or 'F' value direct using any SQL tool ???>>

Yes, it works fine in DBWB

<<Did you put any check constraint on that domain ?>>

The client uses the same charset on connect ? (I don't think this will
be a problem but have a look)CREATE DOMAIN D_BOOLEAN AS
CHAR(1)
DEFAULT 'F'
NOT NULL
CHECK (VALUE IN ('T', 'F'))
COLLATE NONE;

Clay Shannon,
Dimension 4 Software

-----Original Message-----
From: Alexandre Benson Smith [mailto:iblist@...]
Sent: Thursday, March 17, 2005 1:32 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] fake boolean problems


Clay Shannon wrote:

>I created a domain, D_BOOLEAN, that is in actuality a char(1), in which to
>store values 'T' and 'F'
>
>
>
>However, when I attempt to insert a 'T' into that column, I get:
>
>
>
>:
>
>Incompatible column/host variable data type.Dynamic SQL Error.
>
>SQL error code = -303.
>
>conversion error from string "T".
>
>

Can you insert then 'T' or 'F' value direct using any SQL tool ???

Did you put any check constraint on that domain ?

The client uses the same charset on connect ? (I don't think this will
be a problem but have a look)

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005




Yahoo! Groups Links